This topic is locked

master-detial

12/21/2007 10:02:31 AM
PHPRunner General questions
G
garethp authorDevClub member

Hi
I have 2 tables with a master details relationship linked on orderno
order (orderno, duedate)

details(id, orderno, part, duedate)
When I add a new record to the details table I would like details.duedate to be populated automatically with the header order.duedate.
If I edit I record I would like the details.duedate to be changed to the order.duedate (this may have changed since the record was first added).
Hope you can help.

G
garethp authorDevClub member 12/22/2007

sorry I hadn't searched th forum well enought - found the answer at the following link for those interested
http://www.asprunner.com/forums/index.php?...0&hl=insert