Multi Table form

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
 
J

John Vinson

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

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]
 
G

Greg Jesky

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top