AnsweredAssumed Answered

Best Approach To Filter A One to Many Selection

Question asked by sliprat on Aug 20, 2017
Latest reply on Aug 20, 2017 by Malcolm

I'm going to try to explain this the best I can.  We offer a choice of three items.  Basic, Good, Best.


Via a relationship, depending on the group the user belongs to, they get offered three different levels of the item, so not everyone selects from the same three items.  The items offered are from a one to many relationship.  Each item has a price.


If the user selects Basic or Good, I want to offer them an opportunity to upgrade via a Pop-Up Window.


I was thinking I could create a calculation that would compare the price to the item they selected against the other two items available and offer them the next highest priced item, unless they already selected best.


I thought I could figure this out, but I can't get started as I don't know how to formulate the 3 items in the relationship to compare one to another.  Should I parse them into their own fields and then compare them by field?


If you need more information that I didn't explain, let me know.


Thanks everyone!