Populating a foreign key from a seperate form

[MBorda]

I am working on a project to simplify a data entry system.


My goal is to have the users select a number of criteria before entering in data to ensure that they are entering in data with the correct relationships.

Essentially, my problem boils down to this:
I have two forms

On the first form, I am having the users select a series of categories from a number of combo boxes.

On the second form, I have a data entry form. This form has a number of fields that relate to different tables. The data on the second form is partially populated from the first form.

I have three tables all with a 1 to Many relationship. They are Program, Study, and Collection Table. Thus, there are many Collections in a Study and many Studies in a Program.

On the second form, I am entering data that will create new records in either the study or collections tables.

I do not want to have the users re-enter the program level from the first form onto the second form in order to have the foreign key at the study level to populate and signify the relationship between the study and program table.

However, when creating a new record from the second form, the foreign key is not populating for the Study table to relate back to the Program table,
and I cannot save the new record.

How can I take the information from the first form so the foreign keys populate onto the second form for the Study table?

Can anyone assist?

Thanks

[alansidman]

Have you considered making the second form a sub form of the first and linking them using a Parent/Child relationship on the PK/FK.

Alan