I have a DB that I designed 10 years ago. We need to redesign. We have about 10 fields that have some simple look up values. An example would be the type of case. They are either C, L, A, or M. I may at one point add more types, but for now it's the 4. Instead of putting those picks at the table level on the LOOKUP tab, I put them on the forms in the "row source". I'm trying to remember my logic on why I did not put at the table level since if I add another type of case, I will have to go to each form that has the "CaseType" and add it there instead of just one time at the Table level. Any suggestions on why one place is better then the other would be most helpful Using Access 2010. thank you very much--
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.