Stuart McLachlan
stuart at lexacorp.com.pg
Tue Nov 16 19:45:52 CST 2010
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 >