Parent-Child Relationship Help(Please!)

• actinicblue

  Mr or Mrs. 500

  Points: 575

  More actions

  November 8, 2001 at 12:39 pm

  #78075

  I've got a problem figuring out how to get a Foreign Key in one table to automatically coinside to the value of its Primary key in another. Here's what I'm getting at:

  Table 1 has a Primary Key of Company_id

  Table 2 has a Primary Key of Office_id and a foreign key of Company_id(related from table 1) Now I can't figure out how to get the FKEY of table2.Company_id to automatically contain the same value as the PKEY table1.Company_id.

  I'm going to be inserting, updating, and deleting records. One company can have many offices but I can't figure out how to get them related. I hope this is enough info for someone to understand my problem. Thanks.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736255

  More actions

  November 8, 2001 at 2:46 pm

  #419861

  Creating the foreign merely requires that the parent key exist before the child can be inserted.

  I can have:

  Company

  CompanyID Company

  --------- -------

  1 ABC

  2 DEF

  Office

  Office ID CompanyID

  --------- ----------

  1 1

  2 1

  Now if I insert Office 3 with company 3, I will get an error. Becuase the FK cannot be satisfied. If I insert Office 3 with company 2, then it works.

  There is no coincide, you have to insert the data in the correct order.

  Steve Jones

  steve@dkranch.net