In Access 2003 I have a form that the user can change the status of a field on (Ready For Test Field), this then changes the Status field, there may be more than one row that needs to have the Status field changed at the same time as the item may have a number of tests to be carried out, but, it will always be ready for the tests at the same time. Can anyone help me do this? I hope I am explaining what I mean ok, below is a basic idea of how things are laid out.
The tables I have are:
tblJobs - which contains, ID, Customer etc and tblTests which contains the other fields you see below.
In the example below when I tick that either of item ID 1 (the ID relates to a higher level overall job number) is ready I want the status on both items to change. I thought it would somehow be possible to do this by getting the ID of the item that has had the Ready For Test field changed then writing the status into each of the related records in the tblTests, so for example if I made a change to ID 1, all related records in tblTests would be changed to the same status
ID Test No Part Name Test Type Status Ready For Test
1 306 Rubber Hose Fill Test Not Ready Yes/No tickbox
1 307 Rubber Hose Pressure Test Not Ready
2 409 Chain Bolt Pull Test Not Ready
3 etc. etc.
Is this possible? And if so any help is greatly appreciated.