Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    13

    Unanswered: Urgent help needed

    hello

    my db wont allow me to enter data into the main employees table....

    the tables are as follows
    employees table
    emp_id
    emp_name
    emp_surname

    doctor table
    emp_id
    degree info

    nurse table
    emp_id
    skills info

    the docotr and nurse table are joined to the emp table with the primary key for all tables being emp_id but when entering data in the employee table it complains about the referential integegrity etc as it thinks the related table is the doctor one.

    can anyboby explain a way around this as i need what info goes into the employee table to up date the nurse and doctor table where appropriate when entering the data via form.

    i hope you understand this

    can anyone help or advise please

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    try:

    employees table
    emp_id PK
    emp_name
    emp_surname

    doctor table
    doc_id PK
    emp_id FK
    degree info

    nurse table
    nurse_ID PK
    emp_id FK
    skills info

    now each nurse will have skills AND via the emp_id foreign key, also a name & surname

    izy
    currently using SS 2008R2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •