Jump to content
Sign in to follow this  
Matt Malyschko

Related value list in portal

Recommended Posts

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...

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.