Adding Parts to a Repair Order

[joecamel9166]

I am having some trouble wrapping my mind around this. Some direction would be appreciated.
This is for my repair DB. I am trying to add parts to my repair.
Relevant tables are as follows:
tblUnits

• UnitID(PK)
• CustomerID
• Model
• Manufacturer
• etc

tblParts

• PartID (PK)
• PartNumber
• Description

tblPartlist

• PartsUsedID(PK)
• UnitID(FK)
• PartID(FK)
• Qty

My thoughts were to have a subform bound to main form by UnitID and having a combo box on main form to select the part number, and a text box to select the qty, then display Part Number, Description, and Qty in subform.



The only time I need to access the parts used is when I do the invoice for the order and have to show which parts and the quantity were used. Also I would like to be able to run a query on parts used in the future.

I have been trying to figure out how to do this for the last few days, and I'm stumped.

[orange]

Please give us an overview of the set up in plain English.
What is a UNIT? How does a Unit relate to Part(s)?
Do you have a table for RepairWork or work Desciption etc?

[John_G]

Put the Part Selection combo box in the subform instead of the main form, and bind it to PartID field in tblPartList. The quantity should also be entered in the subform, and bound to Qty. Both the PartID and the quantity are related to lie list of parts, so that is where they should be entered. The part description can be displayed in the subform too, if you wish.

This arrangement is analogous to the proverbial orders - order details model that is used to explain how subforms work.