Gabe Posted January 31, 2005 Share Posted January 31, 2005 You've all seen this before, so I'll make it quick. I'm trying to create a drop down menu that will display only related values from another table. The simplest explanation is to say that I have three tables, two main record tables and a join table between them. On the layout for one of the main tables, I have menu set to display a value list which is defined to show only values from the other table starting from the join table. I put a portal on the layout in question to show the same related data, and it is populated with the correct values. The drop down box, however, only shows the first related record. I'm wondering if there is something obvious that I've done wrong? I am going to download the latest developer v7 updates tonight, thinking maybe it will fix some known bugs. Link to comment Share on other sites More sharing options...
Vaughan Posted January 31, 2005 Share Posted January 31, 2005 That sounds about right: each join record may only have one related record in the other main table, especially if you only have a small amount of test data in it at the moment. You may need to re-think what you are doing. Link to comment Share on other sites More sharing options...
-Queue- Posted January 31, 2005 Share Posted January 31, 2005 Try changing your value list to start from the main table. Link to comment Share on other sites More sharing options...
Gabe Posted January 31, 2005 Author Share Posted January 31, 2005 Ah yes, set from the first table. That did it, thanks Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7019 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