[SOLVED] Master Table that filters data to other tables
Good morning,
Please find attached my example.
I want to enter a company address/details only once.
One company can have many different roles.
Presently, I can open up tblADDRESS_MATRIX and enter/amend records, changing the checkbox values as I go, and once saved, it populates the relevant queries with the data - which is great.
However, I want to be able to have a one-to-many relationship coming off every single one of those queries, AND enforce referential integrity, cascade update related fields, cascade delete related records - which a query cannot do. So I figured the best way would be to have those queries as tables instead.
I looked at the append query, and whilst it does work, every time you append the data, it deletes the relationship that the table had, which is no good to me.
Any ideas on the best approach to achieve what i need?
Best regards
manc
Good morning,
Please find attached my example.
I want to enter a company address/details only once.
One company can have many different roles.
Presently, I can open up tblADDRESS_MATRIX and enter/amend records, changing the checkbox values as I go, and once saved, it populates the relevant queries with the data - which is great.
However, I want to be able to have a one-to-many relationship coming off every single one of those queries, AND enforce referential integrity, cascade update related fields, cascade delete related records - which a query cannot do. So I figured the best way would be to have those queries as tables instead.
I looked at the append query, and whilst it does work, every time you append the data, it deletes the relationship that the table had, which is no good to me.
Any ideas on the best approach to achieve what i need?
Best regards
manc
Attachments
Last edited: