Building of Correct Relationship

  • I have difficulty to build relationship for next issue:

    I have:
    1. list of workers (Key: WorkerName)
    2. list of assemblies (Key: AssyID)
    3. list of tests (Key: TestName)
    a. each worker may check zero or more assemblies.
    b. each assembly contains one or more tests.

    I will appreciate your help.

  • Re: Building of Correct Relationship

    You will need to set up a "foreign key" in the assemblies table that relates to the workers table and then another in the tests table that relates to the assemblies table. The set up the relationships from there. Sounds like a one-to-many relationship in each case.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!