Do I Need a Script or Calculation to populate a related field in parent table???
The help I need is knowing if I need a script or a calculation and then how to do it?
I have 4 tables: Workers, Registrations, Jobs, Shifts in that order.
On the parent table Workers I have a portal that includes information from the other 3 tables. Basically the portal tells what job a person is registered for, where, and at what time (shift). Simple eh.
When I create a new job for Worker A in a certain shift, I want to automatically populate a unique shift field (there are 8) in the parent table with a "YES". I've tried "IF" scripts, auto populate, calculations, but can't seem to get it to work properly. What don't I know or what am I doing wrong?
I've included a screenshot and am trying to poplulate the shifts outlined with red box with the info from the portal.
Thanks in advance for your assistance.