replacing lookuptables

[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?

 

[Clifford Bass]

Hi timH,

Interesting problem! If the number is great, then a program might be
the way to go. Otherwise manually may be quicker. Quite what "great" means
would depend on how much work you encounter to make one change multiplied by
the number of places you have to make the change. Roughly. To program it
you probably will need to deal with the DAO.Database, DAO.TableDefs,
DAO.TableDef, DAO.Relations and DAO.Relation objects. You may also need to
deal with the DAO.Indexes and DAO.Index objects. If you need to make changes
to forms and reports also, that will involve more objects.

A backup of the database is recommended before you attempt to do the
changes. Especially if you create a program for it. When coding something
like this, you can mess up royally very easily and being able to revert is
important.

Good Luck!

Clifford Bass

 

[K.timh]

thank you, I understand; at this state i think i will perform it manually.