Hopefully easy question

[abomb]

Hello Everyone,

I hope this is an easy question but I just can't figure it out.

Here's the setup

Table 1-Piece Builder

-Field1- Job Number - such as 1001

-Field2- Piece Number - Unique Number Assigned by Engineer-"1001-1" or "1001-2", etc.

Table 2-Burning Detail

-Field1- Job Number - Relational to Job # in Piece Builder with List

-Field2- Piece Number - Lists only relational pc. # from specific job #. So if Job # 1002 is selected, only Pieces for job 1002 are available to select.

-Field3- Burning Dimensions

-Field4- Bevel - Menu - "Yes" or "No"

Table 3-Rolling Detail

-Field1- Piece Number - relational only to Burning Detail Numbers

There are two other categories linked to Piece Builder that work like Burning Detail Does. Some "Pieces" in a job get burned some don't.

Here's the thing. All pieces that get entered into Burning Detail get burned(obviously), but only some get beveled. I created a value list for Rolling Detail will list all the burning Piece Numbers, but when I go to the Rolling Detail Table I would like to have a list that only generates pieces that get "burned" and "beveled", not a list of all burning pieces. I can't figure out to create my value list to list only the ones that have Bevel Field marked "Yes."

Thank you for any help

[-Queue-]

Create a calculation field of

If( Bevel = "yes"; PieceNumber )

and use this field in your value list instead.