[AccessD] Lookup Tables Implementation

[Arthur Fuller]

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?

On Mon, Jan 31, 2022 at 4:24 AM James Button via AccessD <
accessd at databaseadvisors.com> wrote:

> Back in the (old) days when I was BD'ing
> I would have a table of control info for an app - still do similar for
> Excel
> apps
> Several more columns than were needed for the data  so I could include a
> key of
> 'data usage'  and  depending on the data type stickit in an appropriate
> column
> Means that an app could easily be conditioned for individual users - with a
> record of their own action/options as to the App processing
> Also - access to that set of data could be  limited  via their windows
> login
> and the user data  'added to the department, and corporate logo etc.
> details
> for things that were sold on.
>
> JimB
>
>
> -----Original Message-----
> From: AccessD
> <accessd-bounces+jamesbutton=blueyonder.co.uk at databaseadvisors.com> On
> Behalf Of
> Arthur Fuller
> Sent: Sunday, January 30, 2022 11:35 PM
> To: Access Developers discussion and problem solving
> <accessd at databaseadvisors.com>
> Subject: [AccessD] Lookup Tables Implementation
>
> The basic choices are a physics table and a Value List. I am guessing, and
> with no evidence, that if the Lookup has only a dozen rows or fewer, that
> it is pointless to create a table, but am also suspecting that there is
> overhead involved that I may not be aware of.
>
> Any opinions on this topic?
>
> --
> Arthur
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


-- 
Arthur