Inventory different types of items

[Kristaps_Kraval]

Hi,
Is there an good workflow to keep track of items in one table for different types of items / options.

For example i have small woodworking shop and would like to keep track of -
-screw and bolts many sizes and length
-plywood etc. and it comes with different thickness / size / etc.

So in the end there would be option fields that doesn’t make sense for bolt category and vice versa.

Should i keep each big category in different table?

Thanks!

[ScottWorld]

Welcome to the community, @Kristaps_Kravalis!

It all depends on your workflow, but in general, it often makes more sense to keep all of your items in the same table as opposed to separate tables.

Then, you would create different views for your different categories, and you can hide the unnecessary fields on the different views that don’t apply to that category.

But if you have a small number of categories that need to be separated for some other purpose in your base, it could also make sense to do different tables as well.