I have a radio-button field. For each product chosen in a separate table the same product will have a record including the radio-button. The button has a list of 3 routes. Certain products are route C. Most are route A but could be route B. Both tables are represented in portals on the same layout.
What I'd like is that for when a product is chosen in portal 1, its route is automatically represented in portal 2 and automatically selects radio-button A or C based on a field from portal 1's own route field. However, I'd like to be able to override the choice, for example, to change route A to B.
How do you both calc a result but permit override of that result?