Linking table columns within different tables as a master and slave

[tis_only_me]

Hi, I have a database with two tables. tbl_job_information contains all the contracts info etc. tbl_data contains all the relevant work data. The first table is restricted to certain personnel, whereas anyone has access to the second table. Both tables have a column called 'job no', in the first table it is a primary key, in the second just a field. I would like to make it impossible in the second table to change the data in the 'job no' column to anything that is not in the same column in the first table. It this possible within the tables themselves, or would I have to do it via coding and forms? Thanks in advance.

[pbaldy]

In your relationships you should be able to check "Enforce referential integrity".

[ranman256]

A master form and sub-form should do this with no coding.

[tis_only_me]

Thank you pbaldy, I had set up the join correctly in the relationship but hadnt checked "Enfore referential integrity". It now does what I am after.

[pbaldy]

Happy to help!