This topic is locked

SELECT distinct @ depended dropdown boxes

1/13/2006 9:15:05 AM
PHPRunner General questions
OCTheEagle author

Hi,
Let's say you have the following source table:


When you want to use that source table for putting information into another table you can use a the 'lookup wizard' function in phprunner. The page you create will look something like this:


This can easily be created by choosing 'edit as lookup wizard' at 'products'. In there you choose 'this dropdown is depended on 'name''.
The problem however is that you get duplicate values at the dropdown box 'name'. In my case, you get 9 options -> 5x Henk and 4x Jaap. Is there a way to remove the duplicate values by adding some sort of 'select distinct' option?

admin 1/13/2006

Hi,
sure, check off Unique values box in Lookup wizard dialog on Formattingtab.