Forum Discussion
DonLarson
5 years agoQrew Elite
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
------------------------------
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
------------------------------
MichaelHall
5 years agoQrew Trainee
Hi Don. History would be nice but not necessary. Thank you for the details.
I will apply them and see if that will control things for me.
------------------------------
Michael Hall
------------------------------
I will apply them and see if that will control things for me.
------------------------------
Michael Hall
------------------------------