I apologize for posting this problem which I realize has been posted many times before, however I am stumped as to why this does not work.

On the table called "WO_Entry" I want to be able to select a brand from a pop-up menu. After selecting this brand, I want to be able to select a specific item from another pop-up menu, only displaying the items which relate to that brand.

I have created the self-join relationship for the "Brand" field in the "Item_Entry" table.

I have connected the "WO_Entry" table to the "Item_Entry" table using the LineID field as the match key.

My value list is based on the "LineID" field in "Item_Entry" and only shows related values from the self-join relationship I made.

Any help as to what I am missing would be greatly appreciated!

Korbin

WOD-graph.pdf

WOD.zip

You need WorkOrderData to be related to an Item_Detail TO based on Brand, so that you can limit the value list items according to the Brand. A self-relationship to Item_Detail serves no purpose here, unless you are using the value list on a layout associated with Item_Detail.

See attached for modified file.

WOD-28-Email.zip