Hey folks!
I need help big time. I am in the eleventh hour of creating a really complex database for a buddy of mine and I am in need of a special task.
I need a form the user can use to create a whole NEW table with predefined fields.
For example:
The user needs to track a particular brand of item. So with this db they will have a whole table just for that brand of item. Lets assume the user has a new brand they need to add so they go to this form, they select a name for the table and then the user clicks a create button. Then a new table is created with fields that have been predefined by me. Then using another form the user can make changes to they new table.
What I need help with is how I can use a form to create the table.
I hope what I am asking was a little more clear than mud, lol.
Thanks in advance for any help!