Can't - I'm using the *dreaded* Access! It's only a small system for a
small client and probably won't be getting that many hits.
I tried creating a SELECT query in Access with the JOINing in it, then do an
INSERT INTO qry_mywages, but alas - nowt!
Thanks for your help though...I'm still looking for an easier Access
solution...
Regards.
Sapphire Technologies Ltd.
Secure in the Knowledge
Simon Halcrow Web Developer
E [EMAIL PROTECTED]
T +44 (0)1642 702100
F +44 (0)1642 702119
W www.sapphire.net
> -----Original Message-----
> From: Anthony Geoghegan [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, October 24, 2000 4:38 PM
> To: CF-Talk
> Subject: RE: SQL INSERTs across multiple related tables
>
> What about using a view?
> Regards,
> Anthony Geoghegan.
> Lead Developer,
> What's On Where (WOW!)
> http://www.wow.ie
> mailto:[EMAIL PROTECTED]
>
> --------------------------------------------------------------------------
> ----------------------
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
> a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
-----------------------------------------------
Any opinions expressed in this message are those of the individual and not necessarily
the company. This message and any files transmitted with it are confidential and
solely for the use of the intended recipient. If you are not the intended recipient
or the person responsible for delivering to the intended recipient, be advised that
you have received this message in error and that any use is strictly prohibited.
Sapphire Technologies Ltd
http://www.sapphire.net
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
