2. PHPRunner General questions
  3. datasource tables losing 1 relation
This topic is locked

datasource tables losing 1 relation

 		11/5/2009 3:15:19 PM
PHPRunner General questions
F
 frocco author

I have a foreign key set to table1 from table2

When I hit the next button, and then hit the previous button, the relationship is gone.

I have to drag the pkey from table1 to the fk on table2.
If I repeat, it happens again.
Version 5.2 (2503)
Thanks
Sergey Kornilov admin 11/6/2009

I recommend to open a ticket at http://support.xlinesoft.com sending your project and database for investigation.
D
 		Dale 11/6/2009

I ran into this problem, solved it by better indexing the database table.
I had a projects list, linked to a user list. When I selected the user masterlink from the project list, I would open the edit dialog on the first user in the list, go through the next next next buttons and it would break halfway through. I tracked it back that "IF there was a record in the table that didnt belong to the user set, it broke there.
Looking at the raw database table, I had a current index of User Id then Project Id.

So of course the next user might not belong to the project I used to access the attached users.
I changed it to be more logical, Project Id and then User Id and the problem went away.
Maybe this will help the you.