Check box update field in another table

[Guest]

Can anyone tell me how to tie a check box "true" to update a field in another
table?

I have a cattle auction database. If someone does not bring their animal to
the auction they must pay an out lot charge.

I have out lot field in the table housing the specific animal information as
a check box and an out lot field in the table housing the consignor
information. When the check box is checked in the Lot info Table the
Consignor information table needs to increase by $100. The consignor may
have multiple animals that they originally entered into the sale, but did not
bring so there could be multiple check marks for one consignor.

For example a consignor may sign up 5 animals prior to sale date, but bring
only 3 on the actual sale date. Therefore 2 lots will have check marks which
would result in a value of $200.00 in the consignor table out lot field.

Can anyone guide me with the event procedure to produce this result?

 

[Guest]

Create an update query for the second table
So when you have inputted all of your check boxes you have a button that
runs a query. That will go through table for every instance of the check box
being true it will add $100 to the sellers bill.

Hope this helps

Matt