Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    2

    Unanswered: Populate Junction Table automatically

    I have two tables that I have joined with a junction table to form a many-to-many relationship. One table AIRCRAFT links through the junction table to MAINTENANCE TASKS table. One maintenance task can apply to many aircraft and one aircraft can have many maintenance tasks. The JUNCTION table contains the primary key field from MAINTENANCE TASKS and the primary key from AIRCRAFT to form a composite primary key in JUNCTION. The problem is that the MAINTENANCE TASKS table might have 2000 maintenance tasks in it. When I get a new aircraft, I don't want to add each task one at a time through a form. I was planning to use an append query. Is this the correct way?

  2. #2
    Join Date
    Feb 2004
    Location
    Wales
    Posts
    343
    hi

    a thought

    If you have 2000 checks on a craft and these are standard on first hit could you not set a set of tabbed pages so that these are called from a menu so that it populates your tables in one go. there after revert to a mainenance setup where possibly you could have the crafts requirements broken down in to sections (im not machanical but) ie section header - LANDING GEAR ----- this is then literally a check off of whats required and when it was last checked for this craft?

    regards
    gareth

Posting Permissions

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