Hi,
any ideas
i have 2 tables, tableParent and tableChild,
tableChild is a child table of tableParent,
the relationship is 1-to-many and in tableChild there is a field "tableParentId",
i want to do an update on tableParent and there will be new rows in tableChild,
but what i'm trying to do is:
* remove previous rows in tableChild that corresponded to tableParent
* update tableParent
* insert new rows into tableChild with details of the updated tableParent
any ideas?
Cheers in advance,
Niall