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

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

Original text of this message