update a field in one table based on what is selected in another t

B

babs

I would like to update a main truck table field called( has been assigned)
when in the assigning details the box assigned is checked off. What is the
vb code to update a record in a different table when in the present table -
field is checked yes where truck# are the same????

Thanks,
Barb
 
R

Rick B

Do you have a one-to-one relationship between these two tables? If so, you
don't need that filed. You already have a field to indicate this status,
and putting it in another field would be redundant.

If not, how will you do this when more than one record exists for the given
vehicle? If you have two records and only one is checked, then what?
 
Top