Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2015

    Unanswered: Changes in one table results in changes in the others



    This is (a part of) my db relations:

    Click image for larger version. 

Name:	Subcontractor.PNG 
Views:	8 
Size:	16.2 KB 
ID:	16646

    I'm trying to achieve this:

    Show a form of all applications (application as in to apply for a job). For each application, a subform with the applicant (which is a company) and it's details shown. Then, for each company, the subcontractors are shown.

    The problem:
    I can manage most of this, however not quite all of it. Imagine a situation where company (applicant) has a different subcontractor for a different application. It could be for example that for Application "Fabricate Glasses" there's a company "Shady Sunglasses" working together with subcontractor "Sunny In Philadelphia". For the application "Sell Glasses", it may be that "Shady Sunglasses" doesn't work together with "Sunny In Philadelphia" but with "Rainy Days". However, the subcontractors are linked with the applicant. Meaning that if I change the subcontractor to "Rainy Days' in Application "Sell Glasses', the subcontractor "Sunny In Philadelphia" will be changed in Application "Fabricate Glasses" as well.

    I kind find an error in my normalization, did I overlook something? Or should it work somehow?

    Any help is much appreciated!

  2. #2
    Join Date
    Mar 2009
    Provided Answers: 14
    You should use a Junction table to implement Many-to-Many relationships among applicants and subcontractors. See: (Many-to-Many Relationships) and
    Have a nice day!

Tags for this Thread

Posting Permissions

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