Hi All,

I want to have a few options in a custom dialog based on a related field.  I've been able to successfully get only one option to work using If/Case function (based on the first related record), but the other option does appear.  Let me explain a bit more with an example:

 

TABLE A - fields: Primary Key

TABLE B - fields: Foreign Key, Menu Line Item

I want to have different buttons appear depending on the menu information returned.  I want to have a custom dialog button labeled according to what the relationship returns.  Let's say the first person, call her 'Hungry Henrietta', chooses "Appetizer, Entree and Dessert"  and another person, 'Slim Sam', chooses just "Entree."   When I want to go into Henrietta's order I want a dialog that pops up and says:

"Which Would you like to look at?"

 

Button Option One - Appetizer

Button Option Two - Entree

Button Option Three - Dessert

 

Meanwhile, if I want to go into Sam's order I want to see the following Dialog:

 

"Which Would you like to look at?"

 

Button Option One - Entree

 

The button choices would then perform a search on the backend and take me to a completely different third table, but I know how to do that I think.

I need these to be dynamically adjust position.  I'm also open to other methods - popovers or the like, but I'm not sure how I'd resolve that.

 

Thanks in advance for any help

 

 

 

 

It's not a good idea to use a custom dialog for this, if only because it would be limited to three choices at most. A portal would be a much better choice, because it can show any number of rows (if necessary, through the means of a scroll bar). Just place a button in the portal to perform your script, with the parameter being the selected child's value.

Alternatively, you could make your selection using a drop-down list or a popup menu attached to a global field.

 

Edited March 13, 20169 yr by comment

Thank you