[AccessD] Lookup Table Maintenance

The primary key would then be the TypeCd and ID ?
That should work fine.

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos
> Sent: Thursday, November 18, 2010 3:16 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Lookup Table Maintenance
>
> 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