What do you guys think of Lookup fields in a table? In other words, when creating a new field in a table in Design view, using the lookup wizard to make the list.

...As opposed to creating a seperate table with your lookup fields stored as text.

I vaguely remember reading somewhere that using lookup fields is not very good, as they tend to mess up queries.

Any suggestions? Are they fine to use?

What if the database is upsized to SQL? Will these lookup fields present problems?

thanks!

Hi,

Most experts say that they are not a good idea. See this link.

Hope that helps...

Thank you!

You're very welcome.