You may want to rethink your structure...
Do you have a suggestion? I would simply like to know quickly what products a customer has purchased in the past.
Right click on the field and choose Field/Control>Setup.
In the Field/Control Setup window choose to display as either Checkbox or Radio button.
Choose a value list that contains your 10 products. (use the Manage Value List option to set one up if you don't already have it).
Make the field large enough to show all your products.
The checkbox setting will let you choose multiple products. The radio button setting will only allow one selection at a time (unless you hold the shift key :smileywink: )
Without knowing more it is hard to know if your structure is wrong or not, but typically mr_vodka is right in that you'd want to have the products that a customer purchased be split off into a related table...again, this will depend on your solution and what exactly you're trying to do.
Let me know if you have any questions.
I can't seen to get the product items to be stacked. They are just in a row?
Forget the last comment. I got it! Thanks