Multiple data in one field. (1 Viewer)

[crstphr2]

I am building for a service rental company. They have many different products for rent. These products are classified under "themes". Some of these products are classified under multiple themes. Can it be done so I can enter multiple themes (such as using check boxes) in one filed called "theme(s)"

Thanks for the help in advance.

 

[FoFa]

You maybe better served using a table of "Themes" and a table to tie a Theme to a product. Then you can use something like a list box to display all the Themes for a product without trying to parse and concatenate a field all the time. I mean, how would delete a theme if you needed to without complexe VBA code? At least you can have multiple themes per product this way and can add/delete without much trouble.
Just my thought

 

[crstphr2]

Thank you so much for your help. I see it now.