RETEZE
asked on
Using INSERT to add data into two tables
I have 2 tables. One table 'POHEADER' contains the address, vendor, and PO number. The second table 'PODETAILS' contains the product, quantity, pricing, etc..
I am trying to write a sequel that creates a PO automatically.
I am unsure on how to link up the POHEADER and PODETAILS so the PODETAILS writes data to the correct POHEADER. The primary key is 'POID' (assigned by the informix database) between the two tables.
I am trying to write a sequel that creates a PO automatically.
I am unsure on how to link up the POHEADER and PODETAILS so the PODETAILS writes data to the correct POHEADER. The primary key is 'POID' (assigned by the informix database) between the two tables.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER