[AccessD] Lookup Tables Implementation

Arthur Fuller fuller.artful at gmail.com
Wed Feb 2 07:01:19 CST 2022


Thanks Stuart.
I'll stop doing it.

On Mon, Jan 31, 2022 at 4:42 PM Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> 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?
> >
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


-- 
Arthur


More information about the AccessD mailing list