AnsweredAssumed Answered

Do I Need a Script or Calculation to populate a related field in parent table???

Question asked by MarieT on Nov 21, 2010
Latest reply on Nov 22, 2010 by philmodjunk

Title

Do I Need a Script or Calculation to populate a related field in parent table???

Post

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.

WorkerDB.png

Outcomes