Matt Malyschko Posted August 24, 2012 Share Posted August 24, 2012 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... Link to comment Share on other sites More sharing options...
xtrim Posted September 15, 2012 Share Posted September 15, 2012 can you post a demo file? Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4238 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now