How do I update a child (sub) table

[BrianDickson]

Hi all

I need to update multiple rows within a child table. Is this possible and do I need to have a primary / unique id for each record?

Currently the correct child records are being displayed on a seperate page by passing a "customerID" from the parent table via a URL. The fields are displayed in a table with a "repeat region" server behaviour (Dreamwaver MX). I suspect the fields are not being updated at the moment because mySQL doesn't know which fields in which rows to update, is this correct.

(tables where imported from MS Access, where tables where linked)

Cheers
Brian
🆒

[barand]

You need something to uniquely identify a record for update, but is doesn't have to be an id field. It could be, for example, a combination of customer_id and date, say.

hth