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.

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.

Try changing your value list to start from the main table.

Ah yes, set from the first table. That did it, thanks