Passing unique id to another table
From: Rook <blackrook_at_darkhorsefan.net>
Date: Sat, 15 Apr 2000 00:56:33 GMT
Message-ID: <sfffipemivv144_at_corp.supernews.com>
I have 2 tables
Cus_ID pk
First_Name
Last_Name
Addess
Zip_Code
Phone
[Quoted] address_id
Date: Sat, 15 Apr 2000 00:56:33 GMT
Message-ID: <sfffipemivv144_at_corp.supernews.com>
I have 2 tables
customers
Cus_ID pk
First_Name
Last_Name
customer_address
Addess
Zip_Code
Phone
[Quoted] address_id
The fields are populated by a gui created in visual basic and passed to the
tables via stored procedures
The cus_id is created via a sequence.
My question is, how can I pass the cus_id created by the sequence to the
address_id in customer_Address.
These are not the complete tables I'm using, however I hope it's enough for an
anwser.
Received on Sat Apr 15 2000 - 02:56:33 CEST