Is it possible to fill the fields in Two Tables at the same time with one SQL statement.I hope this makes sense to someone. Thanks for any help. AndyB
Printable View
Is it possible to fill the fields in Two Tables at the same time with one SQL statement.I hope this makes sense to someone. Thanks for any help. AndyB
Hi,
I don't think so...the easiest way is to perform to SQL's...
why would it be a problem..?
DLM
Had you tried using semi-colon(;)?
E.g.
Insert into Table1.......;Insert into Table2......
Regards.
KT