Automatically add, remove or change records in a table depend on other table records

[oham]

We have a table contains some linked fields to other table. For example it has totally 10 fields (5 fields are linked to other table fields). The problem is that how can create such table that contains just some linked fields that add, delete or update existing records.

As u know update queries just can change existing records and can't add or delete new records.

In addition, we have a table with many relationships and it's hard to make new table by make-table queries.

In other words, the difference between what we want and what linked tables does, is that we want just some fields linked between 2 tables not all fields.

[June7]

Not really understanding what you have and what you want. By 5 linked fields do you mean a compound key? Compound key with 5 fields is a lot.

Why would you need to run these action queries?

Provide sample raw data and sample desired results.

To provide db for analysis, follow instructions at bottom of my post.