Combining 1:1 Relationship Tables in a Query

[Sa'El]

Hi All,

I have a long survey that will be passed to a database. To Normalize it I have broken the sections as separate tables. So, for the initial table I have "CustomerID" as the Primary Key and corresponding "CustomerID" fields in the other 16 tables as 1:1 Relationships. At first the other tables had CustomerID as the Primary Key, but I had to remove them as that didn't work when entering the data. So I still have the 1:1 relationships but only the initial table has a Primary Key, which makes sense.

Now I want to combine all the information, but I am stuck. In my mind, I'm thinking that I want the Customer ID in the initial Table automatically passed on to the rest of the tables, but I don't think that's how you're suppose to do it as far as Querying is concerned.



So my question is how do I successfully combine all the information under the same CustomerID while only entering the CustomerID once?

Any help would be greatly appreciated. Thanks.

[June7]

Need an ID field in the related tables to serve as foreign key. This foreign key can be the CustomerID. I hope you still have the CustomerID field in the related tables.

Use form/subform arrangement for entering new records. The subform container Master/Child links properties will synchronize record and automatically save the primary key of main form as foreign key in subform.

[Sa'El]

I see...so it's through the Forms, not Querying that you link them all together? Just curious, would this be the only way to do it?

And yes, I still have the CustomerID field in the other related tables (although if I didn't, I would just add them).

I will test this out shortly and confirm. Thanks so much for your prompt response.

[June7]

The forms are for data entry. The form/subform facilitates saving the primary/foreign keys. This will then allow the related tables to be joined in queries for other purposes, such as building a report for data output.

[Sa'El]

Okay, cool. I got the logic together now, and I successfully implemented the solution, so thanks again June for your help.