I created a product catalog/sales recorder database that isn’t quite working the way I want it. I decided migrating to a new structure will be easier in the long run than trying to fix the old.
Here’s the scenario. I sell greeting cards. Most times, my greeting cards are unique, one time only. Sometimes I create more than one. Sometimes I create several of the same and sell them as a package. The cards are sold at two different local stores, plus online, plus in person to individuals, plus at craft shows.
So, what I for the new design thus far is:
ProductName ProductType Image
Birthday1 Single Card png file
Fireplaces Card Pack png file
Name Location LocationDetail ListPrice QtySold SoldPrice SoldDate
What I would like out of this is a combined table where I can show views by product and/or by store. I’ve tried linking these a couple of ways and I must be doing it backwards as the combined table never seems to have data. I always get confused which way to do the links first.