The repairs table would be a region with the key to the header table. 

The Parts table would be a separate region with the key to the Repairs table. 



Good luck, 

Bernie Lis 



----- Original Message -----


From: "Dan Goldberg" <[email protected]> 
To: "RBASE-L Mailing List" <[email protected]> 
Sent: Thursday, October 27, 2011 6:12:49 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 

Reply via email to