Forum Academy Marketplace Showcase Pricing Features

Database Setup Help for Inventory App

Hey all, love the application, love the community, need some help! :slight_smile:

I’m building an app that does a bunch of different things but one of the main features is to track retail inventory of individual items in a “Style” group. My data would like something like this:

Group: Dresses
1 Small
3 Medium
5 Large
0 XL (out of stock)

Group: Tank Shirt
2 XS Shirts
3 S Shirts
2 M Shirts

Group: Long Sleeve Shirt
1 S Shirt
10 M Shirts
4 L Shirts

One of the views I’d like to show is something like this dirty mock up (size and quantity), possibly with a repeating group(?):

I’m having a tough time figuring out the database structure for this, you can see the project here:

I think I’m going to need another Thing called “Style” and then link the two things together (Style and Inventory) but can’t seem to get it to work.

Any help would be greatly appreciated!