two tables - one update
Please correct my method if there is a better way.
I would like to keep my INV_TBL and INV_PHOTO_TBL separate and have built the two tables with a one to many join.
Photo table has up to 10 images joined by INV_ID.
On the update page, I would like to update the details of the inventory (description and such) as well as an upload file field to insert new images (to the second table)
Do I have two update records with two recordsets?
Do I make the recordset combine the two tables and use one update record?