Forum Discussion

KenDavies's avatar
KenDavies
Qrew Trainee
7 years ago

List - User field used to create child records

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?
Relationships

2 Replies

Sort By
  • ArchiveUser's avatar
    ArchiveUser
    Qrew Captain
    7 years ago
    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.
  • KenDavies's avatar
    KenDavies
    Qrew Trainee
    7 years ago
    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.