Updating a field in a child record based on selecting parent summary value
Not a very good title.
Event (parent to Registration)
Registration (parent to Ticket)
EOTI registers for a specific Event date and creates a Ticket record (working as desired :) )
Now I would like a different role, say MG, to be able to edit a field in Ticket based upon selecting a date (via calendar or pick list), seeing the list of people registered for that date, selecting the individual and updating their Ticket.
I've played with a custom form on Registration which gets the date pick working as I'd like, then displaying a report with the limited fields I'd like the MG to either see or update but when I clicked the field to update, took me to a different report (I think, now that I think about it, maybe have been a form) but all the fields in Ticket were displayed, not what I wanted.
I've played with a custom form on Ticket which kind of works the way I want but the date selection, when I click the dropdown shows me a pick list for reflecting every single Registration date (ie, 30 registrations should me 30 dates even if they are all the same). I'd like to 'summarize' or group the dates.
Still learning all that QB can do for me. My thought process was form on the child (Ticket) and pull from the parent (Registration). Is that part of my thought process correct? Or do I want a form on Registration and use an embedded report to list the Tickets for that date? Once I see the list of Tickets for that date, can I go back to the form to edit the desired remaining fields in Tickets? (even asking this has made me think of things to check out and/or try).
TIA!
------------------------------
Katherine Oakey
------------------------------