Linking Fields between two Tables

[gorgon777]

Hello,

I have two tables called Hardware and Desk.
They both have two fields called ChangeID and Priority.

What I would like to do is set it so that if we change the Priority in a record existing/created in 'Hardware', the Priority of the related record in 'Desk', also changes.

How can I achieve this?

 

[AliyuKatsina]

Hello.
Question. These two tables do they contain same records?

 

[plog]

You don't. Discrete data should be stored in discrete fields: 1 piece of data, 1 field. This data should be stored wherever it is deemed appropriate, then if you need that data as well as data in another table, you build a query to combine the two and get all the data you need. You don't store it in multiple places.