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!