MS Access, Databases and dealing with NULLS.
Posted on 2010-11-29
Curious what some of the more experienced DB folks do as best practice. I have some table that contain lookup fields. Right now, the table that those lookup fields link to only contains valid entries, ie, entries that contain usable data. Not every field though in my primary table is required. So instead of having values, right now they are null fields. Should I add an entry to the linked table that has an empty string or the word 'None". The linked table is just a list of names, Bldg1, 2, 3, etc. The user has to enter up to 4 drop off locations, but is only required to have 1. Should I store "none", "", "?"...?
Just looking for something that other experts typically do...