How to I limit the number of options in a dropdown list?

[delt127]

I have three tables:  Items, Purchases, and Sales.

The "Items" table has the preponderance of information, including a column named "Item_ID" (set up as a key), and a column named "Limited View" (set up as Yes/No).  

The "Sales" table also has a "Item_ID" column (set up as Ref) plus four other columns. 

I created a view of the "Sales" table (set up as a form).  The view/form works as expected, except the dropdown for the "Item_ID" pulls in all 200 items from the "Items" table.  How do I limit the number of options shown in the "Item_ID" pulldown to be the the 15 annotated "Yes" in the "Limited View" column from the "Items" table?

[Joseph_Seddik]

In the column's Valid-if  field, use this expression:

FILTER("Items", [Limited View])

[erasmo]

This seems easier than taking candy from children.

[delt127]

Joseph,

It worked perfect, thank you.  As erasmo stated, easier than taking candy from children.  

Sean