[AccessD] Lookup Table Maintenance

Actually the database I'm working with uses surrogates......but the facility
should work with either.
I didn't mean to get into a religious war ;)

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> Stuart McLachlan
> Sent: Tuesday, November 16, 2010 8:46 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Lookup Table Maintenance
>
> AAAHHHHH!
>
> Natural keys!!!!!!
>
> Run!!!!!!!!!!!!!
>
> --
> Stuart
>
>
> On 16 Nov 2010 at 20:05, Mark Simms wrote:
>
> > Does anyone know of a generalized form with VBA code that allows any
> > and all basic lookup tables to be maintained ? Ideally
> there would be
> > a picklist of all of the lookup tables, and then a form
> would open to
> > add, update, or delete the various lookups. It would apply only to
> > basic referential data having a key and then an associated
> data value.
> > Ex: CarBodyTypeCd, CarBodyTypeDesc CONV CONVERTIBLE SEDN SEDAN COUP
> > COUPE Finally, it would trap any referential integrity violations as
> > well.
> >
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>