One to many relationships

[CoachBarker]

I have 2 tables in my db for tracking Payment Histories and CustomerComments. Both are related to the Customer table, for example: tblComments, CommentsID(PK), CustomerID(FK), RentalUnitID(FK), Comments and CommentDate. When I try to add a record it tells me I need an existing record in tblCustomer(CustomerID). Do I get by this by not checking Enforce Referential Integrity or am I setting up the table incorrectly.

Attachment 1849

[ajetrumpet]

personally, I would eliminate all of the one-to-one's. you can most likely substitute one-to-many's in for them. those are easier to work with IMO. and yes, you can get around your current situation by doing what you stated.

be aware though, that shutting down RI will give you headaches as soon as you want to use a JOIN statement in one of your queries. The data will most likely not be correct in the output set. Either that, or it will error out on you.