I have created a sequence autonumber in SQL called
image_seq, which I am using as the primary key for
the 'order_id' field of a table 'cust_order'.
I have another table, 'product_order' which is linked
to the 'cust_order' table via the 'order_id' foreign key.
This foreign key needs the same value as the other
primary key!
How can I post the same autonumber into both at the same
time?
image_seq, which I am using as the primary key for
the 'order_id' field of a table 'cust_order'.
I have another table, 'product_order' which is linked
to the 'cust_order' table via the 'order_id' foreign key.
This foreign key needs the same value as the other
primary key!
How can I post the same autonumber into both at the same
time?
