2. PHPRunner General questions
  3. Editing the detail table (can't seem to get it right)
This topic is locked

Editing the detail table (can't seem to get it right)

 		3/27/2008 4:19:27 AM
PHPRunner General questions
A
 almonddgr8 author

Hi,
I have two tables, asia_pacific (Master Table, "Case Number" is the Primary key, no auto-increment) and asia_pacific_status(Detail Table, "Case Number" is the Foreign Key), everything seems fine.
Why is it when lets say, on a record in the Master table you have four records in the Detail Table, when I edit one record in the Detail Table, the other 3 entries becomes the same to the edited entry?
Please Help.
J
 		Jane 3/27/2008

Hi,
It seems that you selected wrong Primary key columns for the detail table.

Please specify the correct key columns (not Case number) on the Choose pages tab in PHPRunner.
If you have difficulties selecting key columns you can send me your table structure with sample data and I'll help you.
A
 		almonddgr8 author 3/27/2008

Hi,

It seems that you selected wrong Primary key columns for the detail table.

Please specify the correct key columns (not Case number) on the Choose pages tab in PHPRunner.
If you have difficulties selecting key columns you can send me your table structure with sample data and I'll help you.


I'm sending it to your email right now...
J
 		Jane 3/27/2008

answered in your personal email.