I’m brand new to Tap Forms (and databases) but very impressed with both the Mac and the IOS versions of Tap Forms 5. I’m stuck on how to use a pick list to populate a record in a parent form with multiple fields from a record in a child form.
For example, say I have a parent form called “Neighborhood Pets“. Each record in that form has 3 fields: PetName (text field), BreedName (text field), and VeterinarianInformation (table field?). I also have a child form called “Veterinary Clinics” that contains a record for each veterinary clinic nearby. Each record in that form has 3 text fields: ClinicName, ClinicCity, and VetDrName.
I’d like to be able to use one pick list on the parent form to populate VeterinarianInformation with the 3 fields contained in a record from the Veterinary Clinics form. I guess VeterinarianInformation should be a table with 3 text fields or maybe it could be the name of a Section Heading that has 3 text fields under it that are each linked to their respective text fields in the child form. But how could I populate those 3 fields by selecting the name of the clinic from one pick list? Thank you for any advice on the proper way to set this up.
Hi John,
It’s not directly possible to populate all of those fields in child forms just by selecting a value from a Pick List.
But it could be done with a Field Script. The Field Script could monitor the value entered into field with the Pick List. Then you could add records to the child form and set the field values appropriately.
However, that’s a rather complex bit of coding to do.
How’s your JavaScript?
Thanks,
Brendan
Hi Brendan,
Thank you for the response and for supporting your product so well. I figured out something with a table that I can live with and am very happy with it. I am so new to this —I was trying to link-to-form in the wrong direction and, well, anyway, writing out that question forced me to articulate the problem in such a way that I figured out a solution to what I wanted and learned a little about db relationships, too. Now to dive in to the world of JavaScript….
Take care,
John
.
