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.