Connecting to 2 tables

S

submarine2000

I have a main form, and Test sub form.
When a user changes a field in Main form.
Every record in a Test sub will look up the limit table, and update the
limit field in the Test table. It is triggered from the Main.

I have been successful dealing with 1 table, but I can not do with 2 table.

Please help me. One to read, the other to update.

Thanks.
Jay Lee
 
Top