Check box or radio button
I want to make 10 boxes for each product we sell and I want to put a chekk box or radio button next to the product a customer has purchased. How can I do this?
You should be using a join table.
See this demo in this thread.
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.
Retrieving data ...