Related value list in portal

[Matt Malyschko]

I am having trouble with a value list used in a portal.

Tables I have are:

Items:

ItemID

SupplierID

Description, etc. etc.

Suppliers:

SupplierID

SupplierName, etc. etc.

Orders:

OrderID

SupplierID

Date, etc. etc.

OrderLineItems:

OrderLineItemID

ItemID

Qty, etc.

On the Orders layout, I have a portal that holds records from OrdersLineItems. I want to be able to select ItemID from ONLY the Items that share the same SupplierID as listed in the Order. If I have an ItemID field in the Orders table, it works perfectly using the relationship between Orders and Suppliers. However, once I use it in the portal, it does not work. I assume there is something missing between the relationship from OrdersLineItems and Suppliers, but I don't know what...

[xtrim]

can you post a demo file?