I'm just looking to have a dropdown list for a selection (in this case it is a selection of users, but I have this same case scenario for a simply multiple choice drop down) where the list is populated from another field, but also filtered. As far as I know you have two choices:
1. Multiple Choice Field (or other similar field) and choose to get values from another table. However, this does not allow for filtering.
2. Relate the field, and use a filtered report. This works, but I was trying to avoid creating relationships for no other reason than to get a filtered list.
3. Just thought of this - I could create another field in my source table with a formula that essentially returns the items I want, and is blank for items I dont want. I can use that as the field to get values from...
------------------------------
Mike Tamoush
------------------------------
