Switching from Access, have some questions on grouping products
I am currently using Access with a simple database that has all my products and SKUs. I would like to start using FM for future upgrade options. One issue I would like to hear comments on is how to group products, for example:
Product A has 3 sizes, Small, Medium, Large / Color: Black / Multiple SKUs
Product B has 1 size / Colors: Red, Green, Blue, Black / Multiple SKUs
What approach would be used to still see the items un-grouped in a spreadsheet format, but also combined into a single page format? Particularly I don't like having to update my product bullet point features with each line item, it would be updated per group and spread to the individual SKUs.