I have two tables. The PK from the parent table (Table 1) is a FK to
the child table (Table 2) with a one-to-many relation****p.
On my form, I use a query to return some data to unbound fields from
the parent table for display purposes only. The other fields on the
form are editable and bound to Table 2.
My question is how do I get the data from Table 1's PK into Table 2's
FK field? I am using Table 1's PK as the primary search field for the
form. So, after I select a record, how do I pass only this field to
Table 2? Each record needs this data since it is a FK for the table.
I hope this is clear and thank in advance for the help.
Troy
