INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

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

(OP)
Thank you so very much for the link to "the evils of Lookup Fields in TAbles".  I have people pushing me to move the "pick lists" from the Form "row source" to the table "lookup" tab.  I knew there must have been a reason I designed it that way in the first place but after 10 years I could not remember why.  Thanks again--

RE: Look up at table level vrs. row source

One of the issues is people like to edit records in table datasheet views. IMO, users should never be presented with a table. All interaction should be through forms where you can create/use combo boxes.

Duane
Hook'D on Access
MS Access MVP

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

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.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close