[AccessD] Lookup Tables Implementation

Stuart McLachlan stuart at lexacorp.com.pg
Mon Jan 31 15:42:42 CST 2022

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:

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?

More information about the AccessD mailing list