By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,248 Members | 1,961 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,248 IT Pros & Developers. It's quick & easy.

How to create a new table every time there is a new id field in the form ?

P: 1
there is a field called proposal name in the form.As soon as the name is entered,there should be a new table created for that proposal name.how to do it in VBA?
1 Week Ago #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,419
Hi Shreya.

I don't know where you got the idea of creating new tables for each proposal from, but words are stretched to indicate how bad an idea that is. Beyond bad. It's a recipe for disaster.

Check out Database Normalisation and Table Structures and consider the idea of a single table with all proposals within it and identified separately by some form of Field put in for that purpose.
1 Week Ago #2

Post your reply

Sign in to post your reply or Sign up for a free account.