AUTO LINKING OF TABLES 1

[chubby]

Hi, it's me again!!!! I is wondering how can this to happen.

1. I have 17 tables all linked.
2. only one table has a primary key (called the Case #)
3. All other tables contain case # (but are not a pri key)

Question-How can I make it so when my end users types in the Case # on the master table using a form and that number is placed on every other table?

 

[tlbroadbent]

If you want to Insert a record in each of the related tables when a new record is added to the master, you'll have to write code to insert records in each of the other tables. There is no automatic mechanism or cascading insert in Access.

I would avoid creating all related records when a master record is added. I would insert the master record and then create the other records only when the data for those records is entered. Otherwise, you'll have 16 reocrds containing only the Case# and default values.

If you want to update a case# in all tables when the case# changes in the master table, you can establish relationships, enable referential integrity and have Access perform cascaded updates. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.