I've got four tables

Table 1
id, name

Table 2
id, name, MaN1, MaN2, MaN3

Table 3
id, name, BaN1, BaN2, BaN3

Table 4
id, name, CaN1, CaN2, CaN4

All the tables are empty

I have a form for Table 1 that I use to add data.
I want to use a update query to update Table 2, Table 3 and Table 4 with the data from Table 1

a picture of the query in design view is attach

I want to be able to update table 2,3,4 only when they are empty so at criteria what should it be ??

[Table2]![name] = Null [Table3]![name] = Null [Table4]![name] = Null

Please help....

No No No!! this is a normalization booboo!! Each table should not have id and name duplicated within it

table1
tbl1ID
Name

table2
tbl2ID
tbl1ID
Man1 etc..

table3
tbl3ID
tbl1ID
etc...


see the pattern?

Edit:: Even better...

You should have one ID table and then a table for the Man, Ban, Can....

What are you trying to accomplish with this database?