I'm building a form that lets users manage the app's lookup tables by
adding and (maybe) removing values that show up in various combo boxes
across the application.
The original idea was to show a datasheet listing the names of all the
lookup tables available to the user. The user would select one of the
names, and then be taken to a screen where the selected table's data
could be worked on.
I added a property called "lookup" to all tabledefs in the db. My plan
was to traverse the tabledefs collection and show the user the names
of tables whose lookup property is set to true. Now I realize I have
no idea how to do this.
Can someone point me in the right direction? Or is there a better way
to go about this? In the past I've used naming conventions to find all
my lookup tables in a query, but that would mean renaming a bunch of
tables which I'd rather not do.
Thanks for any help,
-- S