How do I setup an array in SQL Server when a field might have 3 items or might have 10 items?
I need to create a dropdown list that will populate from a query. The user will then select somewhere between 3-10 people that he wants on his team. How do I allow for that in SQL Server?
There are about 20 other fields on this form that need to be created for each record.