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.
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.
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"
)
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!
