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?