List - User field used to create child records

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
I have a List - User field where I select personnel that need to attest to a specific training (parent record).  The training table is related to an attestations table (child record).  I'd like to have a way to automatically looks at the List - User field and create an attestation record for each personnel in that field.

Is there a way to trigger a child record for each user in a List - User field?
Photo of Ken

Ken

  • 50 Points

Posted 1 year ago

  • 0
  • 1
Rather than using a List-User for this, I would suggest setting up the embedded report for the Child Records to be Editable on the form. This way, you could still have the ease of selecting users from a drop-down, but it would be one user per line, which would actually generate the needed Child Records.
Photo of Ken

Ken

  • 50 Points
Hi Blake - Thank you for the response.  I like the idea of child records and using grid edits.  My only problem with that is my users have been adverse to grid edits before, but I just may need to give assurance it's okay and an issue they need to get over. 

I'll most likely move in this direction.  Again, thank you.