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