2. PHPRunner General questions
  3. Lookups dependent on multiple fields
This topic is locked

Lookups dependent on multiple fields

 		11/14/2006 12:02:39 PM
PHPRunner General questions
S
 stoneiii author

I am trying to create three lookup fields. The first is not dependent on any other field on the add page, the second is dependent on the first, and the third is dependant on the selections made for the first and second lookup fields. I have attempted to link them together the problem is the second lookup is not unique, only the combination of the first and second values is unique. Any suggestions for a solution? Thanks for any help in advance.
Sergey Kornilov admin 11/14/2006

The only solution is to add a field to the table that populates second dropdown box and use this field to create a relation between second and third dropdown boxes.