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?
