Hello to all,
I have a situation where I am inserting data into three tables. I can handle inserting into two tables using mysql_insert_id. However, three tables is a bit tricky. If anyone has accomplished this successfully please lend me a hand.
Table 1----Requisition(reqid,Date,Driver,etc)
Table 2----Unit(unitid,make,model,vin,lp)
Table 3----Services(serviceid,oil,cooling,brakes,etc) checkbox data
I have a form with fields from all three tables. I have Requisition table as the primary with two foreign keys for unitid and serviceid. I then have a foreign key in the other two tables for reqid. How would I go about inserting the reqid into tables 2 and three.
Any help is appreciated.
Thank you in advance
