Look up at table level vrs. row source
Look up at table level vrs. row source
(OP)
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--
RE: Look up at table level vrs. row source
I assume the list will change. It would be frustrating to have to go back and find all of the value lists.
Duane
Hook'D on Access
MS Access MVP
RE: Look up at table level vrs. row source
RE: Look up at table level vrs. row source
Duane
Hook'D on Access
MS Access MVP