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

[oham]

I 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, I 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 I want just some fields linked between 2 tables not all fields.

 

[gemma-the-husky]

I think we are struggling to understand your requirements.

you shouldn't need to be making new tables

can you clarify what you are doing. maybe post your table relationships

 

[oham]

Hello gemma-the-husky
Thank you for your attention.
I am creating an access-database. Some of data import from a sharepoint list and others import by access-users.
For example I have a table named APDB in access with 15 fields, and in sharepoint a table named SPDB with 5 fields.
I must note that these 2 tables are same structure and APDB has just more fields.
So I want to update APDB by SPDB's 5 fields and other 10 fields must fill by users.
Regards

 

[sneuberg]

I believe the only way to accomplish this is to create public subroutines to insert, update, and delete and put them in a module so any time you insert, update or delete from SPDB these subroutines are called and APDB is kept in sync. This can become a night mare if you do this from a lot of different places. I'd look really hard for a way to get rid of the SPDB table and just have the APDB table. Could you explain why you are not doing that?