I have a database. Every table in that database has a field called "Site".
When the database is opened for the first time by the end user they will be prompted to enter the name of their site.
I want the value entered to become the default value for the field "Site" in every table contained in the database.
I'm basically looking for some sample code (explained) for how to loop through ALL existing tables and set the default for this field field.
Thank you so much for your help.
When the database is opened for the first time by the end user they will be prompted to enter the name of their site.
I want the value entered to become the default value for the field "Site" in every table contained in the database.
I'm basically looking for some sample code (explained) for how to loop through ALL existing tables and set the default for this field field.
Thank you so much for your help.