if i have 3 tables which are(Customer, Address, Contact), and these 3 tables have the connection as:
Customer have PK 'ID' column which allow Address table using the FK 'CustID' to refer the customer table, and Address PK 'ID' allow contact to refer using FK 'AddressID'
Customer->Address->Contact
ID->CustID,ID->AddressID
i want to create that these three tables can add the data at the same time,how can i do it?because when at the same time Address table need to add the CustID and Contact table also need to add in AddressID while we want to add Customer infor at the same time.
if want to delete how we going to delete the tables information because they have a connection in between these tables?
Pls advise...
|