[thelist] Q on table(s) INSERTs

jsWalter jsWalter at torres.ws
Sat Mar 27 23:54:27 CST 2004


I have 3 tables, each linked to the other...

   1) Event - evt_id
              contact_id

   2) Contact - contact_id
                cpy_id

   3) Company - cpy_id


What I would like to do  is when I create a new contact, that has a new
company, I'd to know how you would INSERT that in both tables.

Same goes for EVENT. How would you INSERT a new event, with a new contact,
with a new company?

I can pull the info out I need alright. I jus can't quite seem to figure out
how to put it in, besides by hand.

Thanks

Walter





More information about the thelist mailing list