Do a search for conditional value list and you should come across many examples.
conditional value lists were indeed the key to the dropdown problem. However, the actual problem still persists:
Assuming I am looking at a list of milestones from ProjectB. I now want to show only Milestones from ProjectA, so I select ProjectA from the dropdown menu.
What actually happens is that ProjectB is renamed to "ProjectA" or whatever I choose from the dropdown. In other words, selecting an item from the dropdown doesn't update the layout with only corresponding milestones, but assignes the currently active milestone to the selected project. Any ideas?
I think that there are two seperate issues here. The first one was the conditional value list which you now have.
The second issue is that you seem to want like to FIND a certain project record. You would want to use some global fields in that case to allow your user to enter in their criteria ( can also use the value lists ) which does not affect the data in the fields. Then you can have a script trigger based on modification of that field which would perform the find ( query ).
that is exactly what I want to do. :) But how exactly would I make a control that shows a value list, but is not associated with the currently selected record? I've tried placing a field with empty "Display Data From" that shows a value list, but FM won't let me do that.
Use a global field. This is a field option you can select on the storage tab of this dialog. (Double click the field in Manage | Database | Fields)