Displaying table names in dropdown

[sdkhea]

Hi,

In our database, we have a table called change_log which is to be filled in whenever someone adds/removes columns from a table in the database or modifies column properties.

One of the columns in the change_log table contains the name of the table which was changed. To avoid typos and misspellings, I would like to create a dropdown which displays all table names in the database. Can this be done programmatically?

Thanks.

 

[FoFa]

Well if the number of tables are small, just create a value list of the values.
You could program it in VBA, but it might be a little slow.

 

[jdraw]

Hi,

In our database, we have a table called change_log which is to be filled in whenever someone adds/removes columns from a table in the database or modifies column properties.

One of the columns in the change_log table contains the name of the table which was changed. To avoid typos and misspellings, I would like to create a dropdown which displays all table names in the database. Can this be done programmatically?

Thanks.

Yes.
I am attaching a module ( containing several procedures) that I use to deal with Tables, Fields etc. It may give you some ideas re Table names, fields etc.
It will create a table (Data_Dictionary) and populate it. You could use pieces of this to compare to existing structures etc.