One Table or Many Tables

Topic Labels: Base design
863 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer


I am trying to create a table of the hardware and materials we use.

What is the best practice to manage varying levels of stepped data.

Fasteners > Hex head screws > 8.8 > Partially Threaded > M12x60

Sections > Mild Steel Angle > 30x30x5

All in a single table?

Multiple stepped tables?

Any advice would be great.

2 Replies 2

You may start with single, and then, when you need some grouping or counting totals for these groups, it’s very easy to add new linked table - just copy-paste whole product type names column into linked field and add upper-level section(s) via lookup or rollup.
But in your case, depending on “how much”, I think you should create at least 2 tables. Or, if you need no grouping/totals, you can leave single and set product type as single-select. Anyway, later you can change it’s type with existing values and it converts to desired field type.

Hm, this is difficult to answer without an understanding of how you’re going to use the data afterwards

Are you going to be assigning said hardware and materials to various jobs, for example? And then would you want to have view whether said hardware was availalbe, or see inventory counts of the materials and such?

With more information about what you’re trying to do I could try to suggest something