Discussions

Expand all | Collapse all

List - User field used to create child records

  • 1.  List - User field used to create child records

     
    Posted 07-27-2017 14:34
    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?


  • 2.  RE: List - User field used to create child records

    Posted 07-28-2017 20:33
    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.


  • 3.  RE: List - User field used to create child records

     
    Posted 07-31-2017 12:29
    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.