casper_vdt
New member
- Local time
- Today, 05:23
- Joined
- Jun 15, 2009
- Messages
- 5
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....
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....
