View Single Post
Old 07-11-2019, 08:36 PM   #2
plog
AWF VIP
 
Join Date: May 2011
Posts: 9,312
Thanks: 10
Thanked 2,262 Times in 2,214 Posts
plog is a jewel in the rough plog is a jewel in the rough plog is a jewel in the rough
Re: Can it be done??

Yes it's possible and you're doing it all wrong.

There's no need to dynamically have a database create tables. There's no need to dynamically name them. There's no need to dynamically build forms upon those tables. If you want a database to track this data, then you should read up on database. I suggest starting with normalization (https://en.wikipedia.org/wiki/Database_normalization), that's the process of properly setting up your tables.

Set up properly tables can accomodate all your data--you don't need to build new tables, or add fields or alter them. Set them up properly initially and they will work for all the data you need.

Perhaps you can better explain your data, perhaps upload a copy of your database. Be sure to complete the Relationship Tool before you do.
plog is offline   Reply With Quote
The Following User Says Thank You to plog For This Useful Post:
NearImpossible (07-11-2019)