Form that writes into two tables

[Zuca86]

I have two tables that have a 1-to-1, total participation relationship which I'm not sure if I have accurately represented. (Every registration must have 1 contact and every contact must have 1 registration.)

My main goal is to have a data entry form that writes into these two tables. When I attempted to create a form for this using a sub-form method, I would fill out on portion of the form related to the registrations table and then when I went to the next portion related to the contacts table, I got an error about the primary key of registrations not writing over to writing itself over on to the contacts table.





Can someone tell me what the best way to approach this problem would be?

[ssanfu]

If it is a 1 to 1 relationship, why not combine the two tables? If it is a matter of real estate, use a tab control to separate the controls - a registration tab and a contact tab.

[Zuca86]

If it is a 1 to 1 relationship, why not combine the two tables? If it is a matter of real estate, use a tab control to separate the controls - a registration tab and a contact tab.

I'm just learning these things now, but there wouldn't be any normalization issues if I did that? If I combine both tables, I wouldn't need a "Contact ID", correct?

[orange]

Do you have a list of specifications or business facts that you are working with?

[Zuca86]

Do you have a list of specifications or business facts that you are working with?

No set of specifications. Not sure what you mean by business facts.

[orange]

I recommend you work through this tutorial. It will help put the pieces together (and make database easier).
http://www.rogersaccesslibrary.com/T...lationship.zip

Here are some business facts, and the datamodel that supports them.
http://www.databaseanswers.org/data_...arts/facts.htm facts
http://www.databaseanswers.org/data_...arts/index.htm model

Here's another set
http://www.databaseanswers.org/data_...sers/facts.htm facts
http://www.databaseanswers.org/data_...s_physical.htm data model

[ssanfu]

I'm just learning these things now, but there wouldn't be any normalization issues if I did that? If I combine both tables, I wouldn't need a "Contact ID", correct?

Correct, no normalization issues; "ContactID" would not be needed.

In addition to the links Orange provided, you might check out

http://www.accessmvp.com/Strive4Peace/