This topic is locked

Mastertable link to a multi line field

12/17/2009 5:36:00 PM
PHPRunner General questions
D
Dale author

Is there a way that I can create a mastertable link to a field in a table that holds multiselect values.
I created a master link

If the multiselect field only holds one value all works fine. But if the multiselect field is holding more than one selection, the master table link does not work properly. It looks only at the first value and stops.
How can I alter the master table link to be a Like %% condition in stead of =.

I have searched, but maybe someone can point me to a post or some information.

J
Jane 12/18/2009

Dale,
unfortunately PHPRunner do not support multiple values in the master-detail relationships.

As workaround you can create custom link to the detail page using Custom format on the "View as" settings dialog on the Visual Editor tab and pass value to the detail page. Then process this value and add WHERE statement in the List page: Before SQL query event manually.