[AccessD] Lookup Tables Implementation

[Stuart McLachlan]

Embedding control formatting in a table efinition is a Bad Idea (TM) for many reasons - 
some of which are set out in the previously linked Allen Browne article and some here:
http://access.mvps.org/access/lookupfields.htm

Don't do it!


On 31 Jan 2022 at 10:25, Arthur Fuller wrote:

> We are all agreed on lookup tables v. Value Lists. But now I have
> another question. My habit has been, over the years, to declare the
> data source in the BE not the FE. In cases where a Query is used, that
> means the query is stored in the BE rather than the FE. The advantage
> is that every form or report created "inherits" this information, and
> automatically creates combo boxes etc. for me. Opinions about this
> practice?
>