Click to See Complete Forum and Search --> : Tables
AndyB
Nov 27th, 2000, 01:14 AM
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
dlm
Nov 27th, 2000, 03:14 AM
Hi,
I don't think so...the easiest way is to perform to SQL's...
why would it be a problem..?
DLM
kleagle
Nov 27th, 2000, 06:03 AM
Had you tried using semi-colon(;)?
E.g.
Insert into Table1.......;Insert into Table2......
Regards.
KT
vbforums.com
Copyright Internet.com Inc., All Rights Reserved.