Unanswered: selecting correct address data from list for a report
I have the following requirements:
User will be asked to enter a customernumber. A list of 1 or more ship-to-addresses should be presented to him/her. The correct address should be selected and these fields will be used in a report. If only one address matches there should not be a moment to choose (obviously) and that address should be used forthwith.
How should I tackle this requirement?
Senior Application Developer BI
SQL, SQL server