Feb 1 2006, 02:50 PM
I have a form that I am working on that is going to have a combo box on it. In the combo box will be 2 choices, ECO or PPC. It seems to me that instead of storing the same value for multiple records in the same table (causing redundancy?), I might want to put these in a table by themselves and link with an ID. Is this the proper way to do it, or should I just stick the actual value in the main table (tblECO).
Feb 1 2006, 02:54 PM
What you should have is an ECOPPC table and put the PK into the main table.
Feb 1 2006, 03:24 PM
I use lookup tables for everything. You never know when you might need to add an additional option to the choices available. If it's not in a table and you're using a combo box, every instance of that combo box in every place it's used will have to be updated to include the new option. If it's in a table, you just have to add another record.
I use tables because of getting bitten too many times with people telling me "oh there will NEVER be more options than just these X". Where x = the number that changed 2/3rd's of the way through development. It's just one extra join and can potentially save lots of work down the road.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here