AnsweredAssumed Answered

Discontinued Products from a drop down list

Question asked by nacrom on Nov 29, 2018
Latest reply on Nov 29, 2018 by nacrom


Good Afternoon All,

 

not so simple question.  I have looked up and down the FileMaker Community and Google trying to find answers with no resolve.

 

In my Database, i have a detail product item (layout) which had ItemID, Size, Weight, and a Active/Discontinued checkbox.

 

On another layout (Job Orders), I have a drop down list which used values from ItemID, and a combined field with Size/Weight.

What i am trying to do is not to have any products show up on the drop down list (Value List) that has the Active/Discontinued box marked as Discontinued?

 

can anyone point me in the right direction on where to research this?

Outcomes