Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like a list box that only show certain values from a particular variabe.
In this example tables 1 and 2 are linked by the item field. If I do a list box on item I get a list of items 1-8, I only want to show 1-4 (based on the "relevent" field in table 2). Is there an expression or am I missing something obvious (probably both)
Item |
---|
Item 1 |
Item 2 |
Item 3 |
Item 4 |
Item 5 |
Item 6 |
Item 7 |
Item 8 |
Item | Relevent |
---|---|
Item 1 | 1 |
Item 2 | 1 |
Item 3 | 1 |
Item 4 | 1 |
Try a field expression (from the field drop selectin list box property) like this:
=if(Relevent, Item)
Try a field expression (from the field drop selectin list box property) like this:
=if(Relevent, Item)
Marvellous - thanks!