[AccessD] Lookup Table Maintenance

Gary Kjos garykjos at gmail.com
Thu Nov 18 14:16:03 CST 2010


How about if you used a single table with all the lookup values in it
with a type field. That's how the big Oracle ERP system we use here
works.

Then you could have a selection combo box at the top to select the
type of lookup you are maintaining and then list the matching details
in a continuous subform below.

Just a thought.

GK

On Tue, Nov 16, 2010 at 7:05 PM, Mark Simms <marksimms at verizon.net> 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
>



-- 
Gary Kjos
garykjos at gmail.com



More information about the AccessD mailing list