Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Showing particular values in list box

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)

Table 1

Item
Item 1
Item 2
Item 3
Item 4
Item 5
Item 6
Item 7
Item 8

Table 2

ItemRelevent
Item 11
Item 21
Item 31
Item 41
1 Solution

Accepted Solutions
swuehl
MVP
MVP

Try a field expression (from the field drop selectin list box property) like this:

=if(Relevent, Item)

View solution in original post

2 Replies
swuehl
MVP
MVP

Try a field expression (from the field drop selectin list box property) like this:

=if(Relevent, Item)

Not applicable
Author

Marvellous - thanks!