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'

The Data Assist Wizard will not automatically insert into 2 different table. However it can be done.

I just did this last week. Here is the thread that I used to get me started.

showthread.php?t=18115&highlight=insert+data+multiple+tables

Thanks for your reply - I'll see how I get on.

Okay, that works, and it's excellent. But can I use Data Assist to create the full CRUD?

Not sure what you mean, the forum post in the link was about using Data Assist.

Please clarify.

Apoolgies - I meant to ask 'can you use the Data Assist Wizard' to create a set of pages (insert, delete, update, results and details) without having to do much hand coding? Is there a thread that shows this process with 2 or more tables - how do I display results, How to I delete from multiple tables?

the wizard can only manage one table.

to manage more than one table on one set of pages, you need to manually add the additional form elements / server behaviors for the additional table, it cannot be accomplished using the wizard.

Okay. Alright, I know how to create the the various record sets and insert the Parent Id into the child table.

But in the directory I want to build, I need to have the facility to insert more than one record at a time into the child table - so you register your family/household in the Parent table called 'Household Table' and you add the first member of that family in the child table called 'Household Members' and your brought to a results page.

An option/link on the results page is to 'add another family member or click 'finish'. Is the Parent table ID session still available, to insert into the child table (2nd time round) when I add a second member or does it get destroyed when you submit it into the child table the first time. See next paragraph for what's happening to me.

I've created a page called 'Add_Another_Member.php', with only the filelds from the child table on this form for additional family members. I've added the Master_Id session variable in the Insert Record behaviour, but when I hit submit, I get an error saying 'Column 'master_id' cannot be null'

Another question - how do you display the result from multiple tables (Household Table and Household Members Table), onto a single page for the viewer to see in their browser?

  when I add a second member or does it get destroyed when you submit it into the child table the first time.  

no, it should not get destroyed. send a copy of the parent insert and child insert pages so i can examine the code.

  Another question - how do you display the result from multiple tables (Household Table and Household Members Table), onto a single page for the viewer to see in their browser?  

this is very similar to showing orders and order details on a page. a good way to do this is by creating two separate results pages in Data Assist, one for the parent table and a second for the child table, then use plugins to display them both.

see the "Displaying Relational Tables with Plug-ins" tutorial on the Data Bridge support page for details:
data-bridge/

Jason, I have attached the file. The main php files are in a folder called 'Jason' inside the 'Jason Folder'. In the meantime I will checkout the tutorial on Data Bridge.