Chris, can you add a screenshot?
Hi Daniel, thanks for your response.
I think my screen shot will not provide anymore clarity. I think if I phrase my question a bit better it might make more sense.
Tables: Users, AvailableBeverages, UserSelectedBeverages.
1. On the user interface there is a portal showing records. These portal records are a list of available beverages.
2. Each user sees the same list of available beverages but not everyone will select the same beverages.
3. If user Dave, clicks on "Tea, Coffee, Soda and Milk", 4 UserSlectedBeverage records will be created for Dave. On Dave's user interface, in the portal showing the list of beverages, "Tea, Coffee, Soda and Milk will now be highlighted to denote that these beverages have already been selected by Dave.
4. User, Tom also sees the same portal showing the list of beverages, but none are highlighted until he makes his selection.
I can make all of this work except for the highlighting of already selected beverages.
You could create a text field in the Users table that stores the IDs of the selected beverages. Using that field (Users::selected) you could create a conditional format that highlights the portal row. It also requires some modest scripting.
Take a look at the attached file and see if that helps.
Highlight_Selected.fmp12.zip 69.2 K
Thank you so much for your sample file. I will implement it this weekend and let you know how I go.
Once again, thank you, I really appreciate this.
You bet. Good luck!
OK, user feedback is implemented and working. The little trick of storing the ID's of selected beverages in a field in the user layout and comparing them to the ID's of beverages available in the portal in order to highlight, is just what I needed. As with any good solution it is simple and elegant and leaves me with the feeling: "Why didn't I think of that?"
Thank you Daniel