I have a database of items. with categories:

Procedures

Lenses

I also have some Procedures flagged as "favorite" with a flag field. I enter 1 if I want it marked as a favorite.

I'd like one drop down, accessed by script (for example, button to show all Procedures or button to show favorite Procedures)

is this possible? I'm really racking my brain here. and can't seem to find out how to define the relationship to be able to show the favorites.

thanks in advance!

If you have a list view of Procedures, you can "hard-code" a find button that finds all procedures where flag_favorite=1.

As for a value list, I'll assume each procedure has an ID and a name. You could create a new field, NameFav_c that is a calc, result text =

if (flag_favorite =1, name, "")

Then make a value list "Favorite Procedures" that is comprised of the ID and NameFav_c fields. Attach that value list to a popup menu.

hi Barbara,

thanks for your reply. I have actually read several of your posts on conditional value lists. and I think I have one of your sample files too.

hard code won't work, I'm interested in having a pop-up menu (or drop-down).

so value list it is... problem is I want one value list (one pop-up menu) that will relate either all Procedures or favorite Procedures. I go to the field with a script, the script sets my related field (category field) to the appropriate category, etc. see example attached file, it might be easier... the "favorite procedures" button isn't scripted yet, but I was thinking I could set the category field to some conacatenated value "P1" to find favorites. but then I wouldn't be able to find "All Procedures" with the same value list (and same drop down menu)...

hopefully you follow my logic/descriptions here. And hopefully, you can tell me where my logic is flawed! :

attached is a simplified version of what I am doing.

-Kevin

px_invoice.zip

bump. I'm leaving for vacation and didn't want to leave drrehak hanging. I'm thinking he needs a setup where he picks the procedure, then whether to show favorites or all, and then the final popup results in a list of values appropriately.

well, I've decided what I want to do can't be done. I have overlapped 2 fields 1 with a favorite relationship, one with all relationship. looks like this will work for me.

thanks again Barbara... have a good vacation. :

-Kevin