I have a question. Is it better to have date fields in say tblProjects or better to have a link to tblDates with a one to many?
==>you wouldnt want each of those fields in a table as a separate field, correct? It is too limiting and requires many separate fields in the tblProjects. It is better to design a tblDates (ID,ProjID (fk), fldDateType) with a relationship to the tblProjects (on ProjID) and have fldDateType as a combo box with a row source qry and a NOT IN event (on the form) to add what a user types that is not in the list.
little difficult to explain without getting too wordy. Let me know if this makes sense. I am pretty sure I am correct on this but wanted some feedback from an expert.