Hi All,
I’d like to draw details from the selected Client in this Choices field that has all of my Clients from the Clients Table but looking at the Data table in the popup at the bottom, it only ever gives me the first Client row.
Is it possible to make this dynamic based on the Client selected within this Choices selector?
As you can see in the screenshot - I’ve selected a different Client but the row still shows my first row.
Many thanks experts!!
Matt
You’re not going to have much luck inside of a form. What you are seeing is the details for whatever table row the screen that contains the form button is linked to when you opened the form. You would need a relation and lookup columns to retrieve the related client information based on the selected choice. When you are in a form, nothing is written to a table yet, so a relation and lookups wouldn’t work. I recommend looking into using a custom form. Basically create a single row table with user specific columns to hold your input values, along with any relations, lookups,and other calculations you need. Then instead of a form, show the detail screen for that new table. Add a button to the screen with an Add Row action to submit the custom form data to whichever destination table you want.
Thank you @Jeff_Hager, I’ll have a go 
Do you only need to display data related to the chosen client, or do you need to do anything else with that data?
Thank you @ThinhDinh but @Jeff_Hager has managed to help me out. 
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
