Dbs Design and Lookup Tables

[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

 

[Denise]

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.

 

[Paul Shapiro]

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.