I currently have a few lists to define things like contact type & purpose etc. These are fairly short lists, though i will also need to make some longer lists as i build the system up further. I want to avoid user error hence have opted for fixed lists.
Currently i have a small table for each list, containing only list values and an auto-value PK. These tables are linked to one parent table each (contacts, address, etc) via a 1:n relationship. I insert the PK of the list value into the parent table with a list box and SQL.
I’m wondering if it is correct to have set a relationship, or, if it is better to handle these list values without one?
One thing i read was to store the values on a table without a relationship; then call the list value directly into a form with a list box & SQL. From what i read, that should allow for easier understanding of data in the parent table, and reduce the risk of data integrity issues. Is this correct?
Im only getting started with queries, so don’t have the experience to properly understand if that side of things will be majorly impacted by this decision.