I have created a site using Adobe Dreamweaver Developer Toolbox using PHP and MySQL.
I have one table in which the user can tick a field to indicate that they have no family members at their address.
If the person decides at a later stage that family members do reside at their address, I want the user to be able to add family members in a related table.
Is it possible to delete the record in the first table, if one or more family members are added in the related table, and for this to be done automatically when the first family member record is added? If it is possible, I'd be extremely grateful if you could point me in the right direction.