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

    Unanswered: multifield primary key related tables form/subform crashes

    I'm fairly new/unschooled at good database design but seems to be simple enough in this situation. Maybe I tried to get too clever with using multiple fields for the primary key in linked tables. I may be breaking a rule of efficient design or something.

    Anyway the database keeps track TUBES stored in CANES which are stored in CANNs which are stored in LMBs (liquid nitrogen tanks) I have set up a table for each with the primary key for tubes being a combination of TUBE# plus CANE# plus CANN# plus LMB#. I created 1 to many relationships and enforced everything.

    Anyway its probably easier to just look at my database.
    Its small. THen i created a main form for LMB with a subform of CANN with a subform of CANE with a subform of TUBE.

    It seems to work well but crashes access after adding a bunch of new records in each table. Particulary after addind some new canes and then browsing the CANNS.

    Does an error or stupid design flaw pop out at anyone.
    Attached Files Attached Files

  2. #2
    Join Date
    Mar 2004
    Posts
    2
    ????? bump

Posting Permissions

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