A
alexasha
i have several databases linked by ID
So far I have three tables Table 1 contains ID, and then table 2 and 3 that
are linked to Table 1 by ID field
each table have forms created (Form 1, 2,3)
I created a command button in form 2 to open form 3. I works fine, but it
opens a blank form and does not transfer ID number to new record. If I would
not fill it manually, then I am not sure how the relationship will be
maintained.
How can I make sure that ID is transferred automatically to new record in
Form 3 using this command button
So far I have three tables Table 1 contains ID, and then table 2 and 3 that
are linked to Table 1 by ID field
each table have forms created (Form 1, 2,3)
I created a command button in form 2 to open form 3. I works fine, but it
opens a blank form and does not transfer ID number to new record. If I would
not fill it manually, then I am not sure how the relationship will be
maintained.
How can I make sure that ID is transferred automatically to new record in
Form 3 using this command button