Master Table that filters data to other tables

[manc74]

[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

 

[arnelgp]

you need to separate each address into tables with one main controlling table.
each table must have the id of the controlling table.

 

[manc74]

Thanks arnelgp for your response.

Appreciate you taking the time to provide your working example. We can most definitely use this.

Thanks very much.

Best regards
manc

 

[arnelgp]

you can add as many addresses as the customer may have.
goodluck with your project.