Table Header Col WorkOrderID [Integer] Table Repairs: Col WorkOrderID - Col LineItemId [Integer] - Col LinkID ((Ctxt(WorkOrderID)) + (Ctxt(LineItemId))) [computed] Table Parts: Col LinkID [text]
----- Original Message ----- From: "Dan Goldberg" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Thursday, October 27, 2011 6:12 PM Subject: [RBASE-L] - one to many to many I have a work order. Each work order has many repairs. Each repair has many parts. Header Table – One Repairs Table – Many repairs to one header Parts Table – Many parts to each Repair I know I can do a one to many form but how do I create a form based on one to many to many? If anyone has any ideas let me know. It would be appreciated!! TIA Dan Goldberg
