Link to home
Start Free TrialLog in
Avatar of Eddie Antar
Eddie AntarFlag for United States of America

asked on

Best place to define combo boxes in Access

So, this is a general question about best practices for building Access solutions. I'm building a new system. In the past, when I've built "main" tables that have lookup fields, I always used the Lookup Wizard on the field type and associated the field with the lookup table right in the table design. But I was wondering what you experts think about that. Should you leave the field as Numeric and design the drop down only on the forms? Does it matter? Is there a speed or index issue?

Let me know your thoughts.

Thanks,
Eddie
Avatar of John Tsioumpris
John Tsioumpris
Flag of Greece image

Always work on Numeric as the bound value
Just use both the key and the display value ...raise the column count to 2 (or more)
and arrange the Column Widths to hide the key
0;5cm 

Open in new window

Change to the equivalent in inches
ASKER CERTIFIED SOLUTION
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial

oh and one other; turn off the auto index and join features.   Especially the first.  Otherwise you end up with a bunch of indexes you don't need.


This is the feature where if a field is named something like "ID", it automatically creates an index for you.


Jim.

Avatar of Eddie Antar

ASKER

Got it. Thank you Jim!