Dbs Design and Lookup Tables

  • Thread starter Thread starter Denise
  • Start date Start date
D

Denise

Is it recommended in the dbs table design to use lookup tab and to select
either list or combo with row source?
Why or why not?
Thank you
 
Thank you once again. While I was waiting for a response, I tried using and
could quickly see that this was not going to work. I will restart ignoring
lookup tab.
 
I agree that it's not so useful for working with the table and queries. But,
setting the lookup properties makes that the default when a field is added
to a form. It is convenient to have a combo box generated automatically with
all the properties setup correctly. So I often do set the lookup properties,
just for that purpose. And it's convenient when looking at a table
datasheet, which is something only the developer should be doing, not users.
If you want to see the id value in a query, you can use TheID: id + 0 as a
column expression.
 
Back
Top