Thanks again for all your hard work on this!
We are using your plugin to register parents and their children for an ongoing membership to a motivational program of sorts.
What I need to do is capture first the adult's information:
Name, Age (must be over 21), Address, Other contact information
Then once I get that, I'd like to have a button that then takes them to another registration page to enter their first child in. In doing so, it'll snag the ID assigned to that parent's record (let's say 001) and in a sense create the relationship between the Parent and the child...pardon the pun, but this is truly a Parent/Child relationship ;-)
They enter in the child's name, gender and age. From the gender and age, I want to create a field that combines those data fields (e.g. for a boy who is 12, it'd be B12) and then appends that with the ID that your plugin has assigned to that new record, so like B12_0002. And then in my custom field parentID inserts 001.
If they have another child, they click a button to add another child, complete the same information (say this time it's a girl who's 8, so G08) and it's G08_003...again also still entering into the custom field parentID a value of 001.
Hopefully that makes sense. As it's not a relational database with multiple tables and joins, I figured this was the best way to do it.
Does this all sound possible with your plugin/database?