Relationships with check boxes

[jamespeters01]

I have two tables. 1) Main table and 2) Returns table. Now apart from the obvious ordernumberid (which is in both tables), I have a check box field in both tables called works_order_completed? Is there any way once this checkbox has been ticked in my returns table that it can be updated and automatically ticked in my main table ??


Cheers

 

[AlexMidd]

Will these fields always have the same value? If so, why have them in both tables? Have one in the main table and it can always be referenced via queries and the relationship between the tables. Have fun! )

Alex Middleton