Skip to main content
Solved

How to setup a base to contain long list of SKUs

  • October 14, 2022
  • 4 replies
  • 30 views
Zack_S
Forum|alt.badge.img+17

Does anyone have suggestions to go one route over another for setting up my base?

Essentially in a table called SKUs I will be linking to another table or tables for each SKU component.
Each of the fields in the screenshot below will be a linked record.

My question is, should I link these fields each to the same table (like the image below) or create a separate table for each component/field type (ex. A table for supplier, pattern, colour, etc.)?

There will be additional information specific to each field/Sku component included as well. Like price per square inch for a specific pattern or prices for inserts, etc.

Thanks in advance!

Best answer by Kamille_Parks11

Suppliers, inserts and sizes only a few. Patterns and colours will be dozens.


Well you could do it one table then based on those numbers. In the table with all these types, create one filtered view per type (only show suppliers, only show patterns, etc). Then your first table’s link fields could have the option “only allow selections from a particular view” and set those views accordingly.

Something you might do is have a Currency field for “Price” and a formula field that displays what the price should be divided by based on the type. I.e.

SWITCH(
{Type},
"Insert", "each",
"Pattern", "per sq inch"
)

    4 replies

    Kamille_Parks11
    Forum|alt.badge.img+27

    How many of each type will there be roughly? You may be better off with 5 different tables. Especially if each type will have multiple different relevant fields.

    Zack_S
    Forum|alt.badge.img+17
    • Zack_S
    • Author
    • Inspiring
    • 95 replies
    • October 14, 2022

    How many of each type will there be roughly? You may be better off with 5 different tables. Especially if each type will have multiple different relevant fields.


    Suppliers, inserts and sizes only a few. Patterns and colours will be dozens.

    Kamille_Parks11
    Forum|alt.badge.img+27
    • Kamille_Parks11
    • Brainy
    • 2679 replies
    • Answer
    • October 14, 2022

    Suppliers, inserts and sizes only a few. Patterns and colours will be dozens.


    Well you could do it one table then based on those numbers. In the table with all these types, create one filtered view per type (only show suppliers, only show patterns, etc). Then your first table’s link fields could have the option “only allow selections from a particular view” and set those views accordingly.

    Something you might do is have a Currency field for “Price” and a formula field that displays what the price should be divided by based on the type. I.e.

    SWITCH(
{Type},
"Insert", "each",
"Pattern", "per sq inch"
)
    Zack_S
    Forum|alt.badge.img+17
    • Zack_S
    • Author
    • Inspiring
    • 95 replies
    • October 14, 2022

    Well you could do it one table then based on those numbers. In the table with all these types, create one filtered view per type (only show suppliers, only show patterns, etc). Then your first table’s link fields could have the option “only allow selections from a particular view” and set those views accordingly.

    Something you might do is have a Currency field for “Price” and a formula field that displays what the price should be divided by based on the type. I.e.

    SWITCH(
{Type},
"Insert", "each",
"Pattern", "per sq inch"
)

    Ok that’s how I currently have it setup but was trying to think about if that would create problems down the road.

    I like the idea with the switch formula. I hadn’t thought about that. Thanks for the help!


    Terms & ConditionsAccessibility statement