I have a quick question about a field for a database I am working on.
This field is called Raw Number, it is anywhere between 2-4 in length, numbers and char.
There will be about roughly 50 the user can choose from or possible create one if needed.
I wanted to know if, I should add this field inside my main table or should I give it a M:1 so the user can select it from a drop down. I created its own table look upbut wondering if I should enter it in main table