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?