I'm sure you cover more complex many-many relationship examples in future lessons, but is this possible? For a maintenance technician log, I can use what you taught to create a many to many relationship between parts and equipment, because different equipment can use same parts. But I would like to establish that relationship in an "WorkOrder" table, where there is also a many-many relationship between WorkOrderID and PartsID. I can look up parts used in a work order, but when I pick parts from a combo box for the work order, I would like it to not only establish the relationship between parts and WO, but also the EquipmentID and PartID at the same time, without having to establish it separately. Is that possible? Thanks!
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 8.