Add Parent and Child in one Save (variation on a previous question)
I have the following tables
Events (Parent to Internet-Clients)
Internet-Clients (Child to Events) , (Parent to Problems)
Problems (Child of Internet-Clients) (also Child to Clients which is an internal use only table)
EOTI 'clients' will 'register' for an Event based on available event date/times. We want to keep statistics on Event registration information. When the EOTI (aka Internet-Client) form is used, a EOTI client will enter their contact info (with required fields) and a problem statement (which I want to go into the Problems table along with possible associated images).
Any way to get the single Internet-Clients Parent and Problems Child added with a single 'Save'? Right now, I have the form(s) working the way I'd like except you have to save the Parent before being able to access the Child (and I want the Problem to also be required as part of this add).
I've thought about the previous answer and putting the problem statement in the Parent record and firing an automation to move the problem to the Child/Problem table but I'd like to avoid having to deal with the images. The images are optional; so there may be none or one or up to four.
It seems as if I make the add on the Problems table, I can't get to the drop down to populate the Event information and I want to keep the Event information tied to the Internet-Clients and not Clients.
I also want to keep Internet-Client data separate from Client data unless someone internal connects the Problem to the correct Client (based on, say, matching email).
------------------------------
Katherine Oakey
------------------------------