Forum Discussion

JabreyHowell's avatar
JabreyHowell
Qrew Trainee
8 years ago

Circular Relationship of tables to display latest applicable reference fields

I have a table of "jobs". I have a table of "personnel". I have a table of "personnel assignments". On my personnel table, I have creates a status column that shows if the resource is availa...
JabreyHowell's avatar
JabreyHowell
Qrew Trainee
8 years ago
It shouldn't, if it does then someone has not ended an assignment when they moved them from one assignment to the other.    When this happens, currently, a number "2" shows as the number of active job assignments for that person which indicates that something needs to be changed.