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.