How to dynamically display the choices in my select box field in record producer based from an existing table?

[John Clyde Ap_a]

I have this record producer that contains a select box

I am trying to display the prices for fields (small, medium, large) when the name of the drink is selected (It is a reference field).

Its basically like this but I was only able to implement this in the normal form. I would like to have a similar outcome for it in the record producer.

How can I achieve this?  Please help.

[Community Alums]

Hello John,

Please don't be sorry, no worries 🙂

Could you please provide me some inputs where you are storing the details of price and choice values and so on? so that I can give the inputs accordingly.

Thanks,

Priyanka R