Normalizing and table update question

[chad101]

I’m working on a new database which will record furnace logs for a heat treat company. I did my best to normalize the tables. I’m trying to add new records through a select query which updates multiple tables. My problem is I don’t believe I did that great of a job normalizing the tables because I continue to get errors stating I have duplicate entries. It dose not make any sense because each table uses an auto number as the PK and one FK value from the tblProcessFurnace which is an auto number. Every new record should increment the PK. Thus making it impossible to have duplicate values.

 

[chad101]

thank you

Thank you I’m looking for this selection under tools->options but I don’t see anything about creating an index. I have looked under all the tabs.

I redid my forum so everything is updated through subforms.

What about table normalization dose everything look ok?

 

[chad101]

thank you

Ok I removed all unnecessary indexes, fixed the circular relationships, and renamed my foreign keys to correspond with the PK. Thank you for the help =)).