I have three tables, related by a field that is the same in all tables. Tbl1 is the master Tbl2&3 are like the subs. Tbl1 is filled through entry in a form. I need the entry in the form to automatically create records in tbls2&3 using the value entered for tbl1.field1.

I offer my thanks in advance!

Update Queries. Run after you enter the data on the first form.

There has to be another way. The update query is trying to create all the field1.table1 values. I need some sort of not in list criteria to make it work. Even worse i'm getting validation rule errors and i don't have any validation rules set. The format of the field is the same in each of the sub tables.

[This message has been edited by yeatmanj (edited 10-20-2000).]

I appreciate the input on this one. I had o use two queries. One to get the info and one to append. The only way i could find to get around the validation errors. Again Thanks.