Auto-populating sections of parent table form single child table
Hi all,
Very beginner database manager here, so bear with me as I try to speak database language.... especially when I try to keep my terms straight when dealing with child/parent table to table relationships that are specifically related to real human children/parent data sets.
It seems I use Quickbase a little differently than lots of folks - to manage a youth program's participants.
The challenge I'm having is in integrating two different child tables into a single parent table. Basically, I have two participant-generated datasets that I import into separate similar tables: I want to cherry pick a few lines of data from each and auto-populate into a pre-existing single parent table. I can only figure out how to make it work the other direction - for data from the parent table to be a lookup field in the child table.
Here's the frame of reference for my workflow: I work with human kids, and initially create a very basic master "kid profile." After I create a "kid profile" I receive separate Google forms (intake forms) from each "kid" and "mom&dad" - and would like certain fields from each "kid/mom&dad" intake form to auto populate the master "kid profile."
These current Google Forms used to be paper forms that were entered manually, but we are working toward better automating this work flow.
Thanks for the help!
------------------------------
Ben Johnson
------------------------------