This topic is locked
[SOLVED]

 Multiple selection and detail table problem

8/7/2019 12:19:06 PM
PHPRunner General questions
H
harveyspecter author

Hello,
I have a field and it has multiple selection option. I select names from another table:



and when i save it after add page its shown in list page like this:



I also have a detail master table relationship with the names table.
I can see info of the name i choose when its choosen only 1 like this:



But if the field has multiple choice I cant see info of no one..:



Can you help me for this? I need to see info of two of the names when I add multiple selection.
Thanks alot.

Sergey Kornilov admin 8/7/2019

It looks like you are not using Master-Details relationships properly. You do not list all details IDs in a single field of a master table. There must be a link field in both master and details table that contains a single ID.
See this for the proper tables structure:

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

H
harveyspecter author 8/22/2019



It looks like you are not using Master-Details relationships properly. You do not list all details IDs in a single field of a master table. There must be a link field in both master and details table that contains a single ID.
See this for the proper tables structure:

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


Thanks it solved!