Multi Table form

  • Thread starter Thread starter Greg Jesky
  • Start date Start date
G

Greg Jesky

Just a basic question. I have not been able to update 2 tables with one form
without rekeying the same field(used as primary and foreign key) in the 2
tables.

Table 1: Contract Id (PK), Start Date, Termination Date, Min. Annual
Commitment

Table 2: Billing Account No(PK), Service Provider, Contract Id(FK), Major
Account Number

Some of the contract ID's can get very lengthy. Is there a way to create a
form so I can type Contract ID once and have it placed in the other field of
the form and then update both tables?

(PK) means Primary key
(FK) means Foreign key

Thank You,
Greg
 
Just a basic question. I have not been able to update 2 tables with one form
without rekeying the same field(used as primary and foreign key) in the 2
tables.

Table 1: Contract Id (PK), Start Date, Termination Date, Min. Annual
Commitment

Table 2: Billing Account No(PK), Service Provider, Contract Id(FK), Major
Account Number

Some of the contract ID's can get very lengthy. Is there a way to create a
form so I can type Contract ID once and have it placed in the other field of
the form and then update both tables?

(PK) means Primary key
(FK) means Foreign key
Click to expand...

Yes; use a Form based on Table 1 with a Subform based on Table 2,
using the Contract ID as the master/child link field. This has the
added advantage that you can use a Continuous Subform and view
multiple billing accounts/service providers for each contract, and see
them all on the form at once.

John W. Vinson[MVP]
 
John,
Thank You,
I will try it!
Greg


John Vinson said:
Yes; use a Form based on Table 1 with a Subform based on Table 2,
using the Contract ID as the master/child link field. This has the
added advantage that you can use a Continuous Subform and view
multiple billing accounts/service providers for each contract, and see
them all on the form at once.

John W. Vinson[MVP]
Click to expand...
 
Back
Top