K
K.timh
Is there a program I can write to replace a couple of lookup tables with a
single lookup table?
explanation:
I have a data base where a lookup table with the name of ltblYN (look up
table yes no) is linked to a number of tables where the response was to be
yes or no. This was meant to be expandable so if Not Applicable was needed it
could be added, unfortunately in my absence someone added the look up table
yes/no/na and yes/no/not recorded/not applicable.
my dilemma is that multiple tables have links to the three look up tables
and i would like to eliminate two and keep one of the lookup tables, so am
asking if there is a program I can write to do so or do i have to go to each
table in properties and manually remove, link and save prior to removing the
extra lookup tables?
single lookup table?
explanation:
I have a data base where a lookup table with the name of ltblYN (look up
table yes no) is linked to a number of tables where the response was to be
yes or no. This was meant to be expandable so if Not Applicable was needed it
could be added, unfortunately in my absence someone added the look up table
yes/no/na and yes/no/not recorded/not applicable.
my dilemma is that multiple tables have links to the three look up tables
and i would like to eliminate two and keep one of the lookup tables, so am
asking if there is a program I can write to do so or do i have to go to each
table in properties and manually remove, link and save prior to removing the
extra lookup tables?