Submit data to two datasets, 1 is new record, the other is updating a field.

Ask the community
,
1

I’m guessing I need to disengage the Submit button I already have and manually code it to accomplish this. Title says it all but here is some detail…

I’ve got 3 input fields and an upload button. The 3rd field is a dropdown that shows a list of accounts pulled using a query from Accounts dataset. I’m trying to to create a new record in Display dataset with all info plus the uploaded image. At the same time I want to tag the same account in the Accounts dataset putting a value in a field that indicates there was a submission. Am I over thinking this? Is there a way to do this in the datasets? or do I just code a submit button:

  1. find record in Accounts dataset matching the selection in Field3(dropdown)

  2. update “Display” field in record

  3. insert new record with all fields into dataset “Display”

Thoughts?