I am building a pricing application, and i am wondering the best way to control returned values, meaning that if I enter a customer name in a text box, within a form, how do I get the rest of the information specific to that customer to auto fill the remaining spaces, or in the case of pricing, when a customer is selected, it will return pricing for all the selected items specific to them. Would this best be done through a Microflow? Or some other option?
If you use text box with autocomplete, then you have a foreign key relationship between your current entity and custom entity. Two ways to solve the problem:
You create readonly fields (reference selectors) on the form reading customer attributes over the key.
Create data view to show customer entity selected by text box