copying autonumber value in one field to other tables

[tmcavilee]

i have a database designed with 4 tables linked only by the customer
id# which should remain constant. i cannot figure out how to program
this to copy the customer id# from the main table to the linked
tables. can anyone help?? if not i might go bald.

 

[Guest]

Do you have your Table Relationships set with Referential Integrity and set
up to Cascade Update Related Fields? Because it sounds like your tables may
not set up with the proper relationships. If this is the case, I recommend
that you do a Google Search for Microsoft Access Tables Relationships ,
and find a site that helps explain how to set up your table relationships to
automatically update the ID numbers.

Hunter57
http://churchmanagementsoftware.googlepages.com

 

[Jeff Boyce]

You've described what you want to do, but not why. Why do you think the
CustomerID belongs in the four linked tables? What is the relationship
between your main table and the linked tables? What kind of data are you
storing in these tables?

More specific description will probably result in more specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[tami]

You've described what you want to do, but not why. Why do you think the
CustomerID belongs in the four linked tables? What is the relationship
between your main table and the linked tables? What kind of data are you
storing in these tables?

More specific description will probably result in more specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP






- Show quoted text -

It is a customer database. On the main form I have the basic customer
information, the four additional forms contain financing information,
marketing information, park model information and customer follow up
information. The only common bond between them is the customer id# but
it needs to remain constant throughout the record. I would appreciate
any help in this regard. Thank you.

 

[Jeff Boyce]

Tami

One approach would be to use a "main" form for basic customer info, then use
a tab control with four pages, one for each additional table. Build one
form per table, including the customerID.

Now add one form (as a subform) to each tab page. Use the Parent/Child
properties of the subform control to specify that customerID on the main
form needs to match customerID on the subform(s).

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[tami]

Tami

One approach would be to use a "main" form for basic customer info, then use
a tab control with four pages, one for each additional table. Build one
form per table, including the customerID.

Now add one form (as a subform) to each tab page. Use the Parent/Child
properties of the subform control to specify that customerID on the main
form needs to match customerID on the subform(s).

Regards

Jeff Boyce
Microsoft Office/Access MVP







- Show quoted text -

You ROCK!!!! Thank you very much for your help!!!!!!!