Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

Figures, Products and...superproducts?


This topic is 4124 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

I'm having trouble determining the best setup for this database. It has, at the core, figures and products. a figure being a particular toy, a product being that figure in its box or multiple figures in a box. 

 

So I've got a figures tables and a product table and a "product contents" or product/figure association table. That all works fine. Where I get stumped is when there's different "levels" of products. For instance, one of the products we're trying to track is a box that contains up to 24 smaller boxes with figures in them. This Super Product contains multiple other products, but is basically just a box. like actual physical 4-sides-and-a-bottom made of cardboard box. It doesn't have its own UPC or licensing information, but does go through the whole process of design and color testing and such. 

 

My question is, should I make a new table for these super products, or should i attach the box to the products themselves and have a field to relate the products to each other when/if they show up in the same box? 

 

Any opinions would be appreciated. 

Posted

If your definition of 'product' is "figure in its box or multiple figures in a box", then "a box that contains up to 24 smaller boxes" does not fit your definition of 'product'.

 

What do you do with your products, and what part of your operation is this solution part of? Are "superproducts" treated the same as products in all the steps of your operations? Is there ever a need to make a distinction between 'products' and "superproducts"?

This topic is 4124 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.