Looking for some advice on Lookups.
I’m designing an app that will have about six lookups.
I want to put these in tables, rather than enums, so they can be updated.
I’m thinking of putting them all in one table, having a ‘type’ column, as well as the lookup value column (they will all be Text type), so that I can use a Valid_If to filter by lookup type to get the relevant lookup values in the relevant parts of the app.
Is this normal/efficient?
I just don’t want to have six lookup tables.