[SOLVED] Â Auto increment field ADD detail records |
12/29/2014 9:07:18 AM |
PHPRunner General questions | |
G
GregJ author
PHPR 8, mySQL. |
|
![]() |
Sergey Kornilov admin 12/29/2014 |
Link two tables as Master-Details and choose 'Display child records on Add page' option. This option can be found in master-details relationship properties. |
G
|
GregJ author 12/29/2014 |
Link two tables as Master-Details and choose 'Display child records on Add page' option. This option can be found in master-details relationship properties.
|
![]() |
Sergey Kornilov admin 12/29/2014 |
If you follow my advise both master record and details records will be added at the same time and master key value will propagate to details table. |
G
|
GregJ author 12/29/2014 |
If you follow my advise both master record and details records will be added at the same time and master key value will propagate to details table.
|
![]() |
Sergey Kornilov admin 12/29/2014 |
Yes, it's very simple - remove Ordernum and order# fields from details tables Add/Inline Add pages. |
G
|
GregJ author 12/29/2014 |
Yes, it's very simple - remove Ordernum and order# fields from details tables Add/Inline Add pages.
|
G
|
GregJ author 12/30/2014 |
I finally got this to work. I had to connect to my project tables through PHPmyadmin and purge them. They didn't look like they had corrupt data in them but something in there was preventing the detail tables from updating. Hope this doesn't re-occur when I have live data in them! |