G
ginger
how do I edit data so that records in primary table exist for all related
records in Access building table relationships?
records in Access building table relationships?
J
John W. Vinson
It sounds like you have it backwards. Normally one would create the "parent"
record first, and then (using a subform, or other techniques) create "child"
records related to it.
That said... the relationships between records depend *on the data in those
records*. Each table should represent a class or "Entities", real-life people,
things, or events. The relationships between these entities exist in the real
world; the tables merely represent those relationships. Therefore it makes
little sense to talk about "edit[ing] data so that records in primary table
exist" as if the table relationships were arbitrary!
What are these tables? What's in them now? What Entities do the tables
represent? What real-life relationships are you trying to model?
- Joined
- May 31, 2011
- Messages
- 1
- Reaction score
- 0
Hi I was looking into a similar issue on my DB. Im having the same issue. If you can help me please.
My data base is trying to link clients(table) and his contacts(table related to Clients table), with my suppliers (table) and my contacts( table related to suppliers) into a single table containing the projects. So for 1 client I have many contacts and for my suppliers I have many contacts. now each project will have 1 client and 1 coordinator from the clients contacts table and 1 supplier and 1 coordinator form the supplier contacts table. The relationship is working for the supplier and related contacts, but when I try to add the relationship to clients and the related client contacts I get the error message.
"Microsoft Access can't create this relationship referential integrity.
Data in the table 'Projects' violates referencial integrity rules.
for example, there may be records relating to an employee in the related table, but no records for the employee in the primary table.
Edit the data so that records in the primary table exist for all related records. if you want to create the relationship without following the rules of referential integrity, clear the enforce referential integrity check box."
Well hope you guys can help me. Thanks
My data base is trying to link clients(table) and his contacts(table related to Clients table), with my suppliers (table) and my contacts( table related to suppliers) into a single table containing the projects. So for 1 client I have many contacts and for my suppliers I have many contacts. now each project will have 1 client and 1 coordinator from the clients contacts table and 1 supplier and 1 coordinator form the supplier contacts table. The relationship is working for the supplier and related contacts, but when I try to add the relationship to clients and the related client contacts I get the error message.
"Microsoft Access can't create this relationship referential integrity.
Data in the table 'Projects' violates referencial integrity rules.
for example, there may be records relating to an employee in the related table, but no records for the employee in the primary table.
Edit the data so that records in the primary table exist for all related records. if you want to create the relationship without following the rules of referential integrity, clear the enforce referential integrity check box."
Well hope you guys can help me. Thanks