2. PHPRunner General questions
  3. [SOLVED]  Error relationship
This topic is locked
[SOLVED]

 Error relationship

 		11/11/2019 7:32:00 AM
PHPRunner General questions
L
 luchoadmin author

hello dear, I have an error in phprunner 9. when creating a database relaionship. after making a visualization of the detail of a load. when I am going to load a record again the field that is related appears to me only reading








https://drive.google.com/open?id=19GvNfVChmk3Iyxckog57s6_i-sav2xP1

https://drive.google.com/open?id=1qnb-C0yzcw71ctNnFvzUuSQuOvNSSNQv

https://drive.google.com/open?id=1psiiZIcOtylu_voR9fR2kDcG4ZM52LrG

https://drive.google.com/open?id=1Onq41Zs2tVxXWHmZIYa9lHyiNakyKr0F
I await your help
L
 		luchoadmin author 11/11/2019

important when I disconnect and reconnect it works again until a detailed view and the error appears again
M
 		mersintarim 11/11/2019



important when I disconnect and reconnect it works again until a detailed view and the error appears again



connection must be a field other than the master key
L
 		luchoadmin author 11/12/2019



connection must be a field other than the master key



Hi

I put the ID field as the primary key and the error continues. any other idea
M
 		mersintarim 11/12/2019



Hi

I put the ID field as the primary key and the error continues. any other idea


detail table must have id field and connection field
you connect master and detail table with connection field
Sergey Kornilov admin 11/13/2019

I'm not seeing any errors on either of those screenshots.
Anyway, Mersin is correct. In the details table, you need to have two fields, primary key field, and a link field. The link field is the one you use to link master and details together. See this for more info:

https://xlinesoft.com/phprunner/docs/master-details.htm
L
 		luchoadmin author 11/14/2019



I'm not seeing any errors on either of those screenshots.
Anyway, Mersin is correct. In the details table, you need to have two fields, primary key field, and a link field. The link field is the one you use to link master and details together. See this for more info:

https://xlinesoft.com/phprunner/docs/master-details.htm


Hello,

Today I found the error, when I edited the menu and changed several links to the list pages by add the error occurred.

they know how to solve it