Unanswered: macro for opening new record and copying primary key
I have 3 tables:
PD: personal data,
FE: first event
Each hay unique primary key. They are related one to many: PD-one to many- FE and FE-one to many-RE.
I am working on form. I have part of screen for personal data. If I have new custumers I have to write personal data first. Then I have two butons for starting new record in FE, and would like that when I press that button it would open form for FE writing, it would copy the ID valu of current record into FE, where it would be secondary key - for relation.
Hwen I press button for RE it would be same as for FE just that it would also show me all FE records for the current person so that I could select the wright "first event" that the"reevent" is dependant on.
Is that too complicated? or too copmlicated asked?
Substituting your names of course. If the new form isn't set to data entry, you'll probably want to open it in that mode. You might also consider using a subform instead of a standalone form, where the master/child links will take care of this type of thing automatically.