Matt Malyschko Posted August 22, 2012 Share Posted August 22, 2012 I have two tables: Items, and Suppliers. I have a value list to display Items, related to Suppliers. When I update the Items, and add new ones, the value list is not updated... I had to edit the value list, and confirm it was stil set up the same, and then when I selected OK it was updated... Why is this? Actually, it's not updating at all. When I go to select the item in the field where the value list is attached, it comes up as no values defined. I then change the value list to display all the items (not just those related) and I can select the item. Then once I change the value list back to being related, it only shows the single item I had previously selected (even though there are multiple ones that share the same supplier). Link to comment Share on other sites More sharing options...
dansmith65 Posted August 22, 2012 Share Posted August 22, 2012 Probably a mis-match of context. Meaning the Table Occurence of the layout you are trying to access the value list from, is not the same relationship group as the value list is based on. Link to comment Share on other sites More sharing options...
Matt Malyschko Posted August 22, 2012 Author Share Posted August 22, 2012 Probably a mis-match of context. Meaning the Table Occurence of the layout you are trying to access the value list from, is not the same relationship group as the value list is based on. I have Orders (orderID) --< (orderID) OrderLineItems (itemID) --< (itemID) Items that is how the tables are related, and their is a portal on Orders, holding LineItems, and the value list comes from Items (related to suppliers via SupplierID). Link to comment Share on other sites More sharing options...
Lee Smith Posted August 22, 2012 Share Posted August 22, 2012 Are your related id fields all of the same type i.e. Text. Link to comment Share on other sites More sharing options...
Matt Malyschko Posted August 22, 2012 Author Share Posted August 22, 2012 Are your related id fields all of the same type i.e. Text. Yeh they are all a Number. Link to comment Share on other sites More sharing options...
dansmith65 Posted August 22, 2012 Share Posted August 22, 2012 And how is your value list defined? Link to comment Share on other sites More sharing options...
Lee Smith Posted August 23, 2012 Share Posted August 23, 2012 is there any text in the makeup of the ID's? Link to comment Share on other sites More sharing options...
Matt Malyschko Posted August 23, 2012 Author Share Posted August 23, 2012 And how is your value list defined? Use values from first field: ItemID (Items), also display value from second field: Description (Items). Include only related values starting from: Suppliers. This should mean, if there is an ItemID that shares the SupplierID listed in the Order, it should appear in the value list? is there any text in the makeup of the ID's? No there's not. It's an automated serial number. Link to comment Share on other sites More sharing options...
Matt Malyschko Posted August 24, 2012 Author Share Posted August 24, 2012 After some more research it appears my issue is having the field in a portal. Orders holds a portal containing OrderLinesItems fields. I assume this means that as each record in OrdersLineItems doesn't actually contain the SupplierID, and in turn doesn't have related records. When I put an ItemID field in the Orders table, and have it outside the portal, the value list I am trying to create works fine. How do I go about fixing this? Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4263 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