I am trying to make a form for freight requests. I have a sold-to party table, and the first field combines all of the individual customer values into one combined cell.
Essentially, what would be column A is equal to Column B+C+D+E+F.
When I am creating a form that has a selection referencing this table, I would like to just reference that combined column only, with the selections being shown in the drop down, or when searching for the selection. Is this possible? Currently, when I use a connection from this table for the form, you can only search by the customer name, and you cannot see any of the combined field data.
The need comes from the fact that many of our customers have different sold-to codes due to their locations varying in processes. So, Customer A may have 3 different version to choose from.
