At 06:12 PM 10/27/2011, Dan Goldberg wrote:
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!!
Here's how:
While in form designer ...
01. Make sure to add all slave tables accordingly.
Main Menu | Tables | Add or Remove Tables ...
Add all "Slave Tables" in the correct order
02. Now select the Many-To-Many Relationship
Form Properties | Table Relationship
Click on Many-To-Many Table Relationship Radio Group.
That's all there is to it!
Very Best R:egards,
Razzak.
P.S.
Use R:Column Analyzer 9.1 Plugin to view the exact Many-To-Many
relationship between selected tables.
Database Explorer | Utilities | Plugins | R:Column Analyzer 9.1
