Single Child to Single Parent

Michael,

Do you need to know the history of the assignments?

In the Parent Child relationship the Child can only have one Parent. You can allow the User to change the associated Parent.  The business case might be moving test equipment around the plant.  The test gear can only be connected to one machine at a time.



If you want to keep track then you need a different architecture


You have to build logic into the application to prevent assigning a Unit to a piece of Equipment until the last Assignment is done.   You would do this using a Summary field between the Units and Assignments table on the Record ID# in the Assignment table.


Here is a screen shot showing this:



This will tell every Unit if it has an Assignment without a Stop date.


------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------