Using Data Assist with Relational Databases
Dear Jason, can I use Data Assist, in a scenario where I have two tables.
I want to build a site that has a table called Household/Family. I have another table for Household/Family members.
I would like a Household/Family to register and add members in their household/family. The 'Household table' would have a column for household name, username and password. The other table, 'household/family members' table would have columns with first name, last name, phone, email, age.
Can Data Assist build an 'insert page' that will include fields from both tables on the insert page? I would then have a button on the insert page to 'add another member to this household' and you could continue adding to this household/family or I would ideally like to add multiple members at once. How do you get the fields from the various tables onto the one registration page/form?
I would also like to allow the Households/families who are registered to have the ability to add or delete members to their household. They should be able to 'add' at any time - as long as they are logged in - because they may want to add 'new arrivals' or delete members who have 'flown from the nest'