Create a new Table from Form

[hece99]

How do you create a table of records from a form/subform?

 

[plog]

You don't.

Tables aren't meant to be generated on the fly or dynamically. They are to be thought about, meticoulusly structured and then the form built atop them.

Can you provide a big picture idea of what you are actually trying to accomplish? What's this database for?

 

[hece99]

I am creating a quotation data base with calculations. I created a form with a subform using fields from several tables (Customer, customer discount, item description, item sizes, quantity price breaks, etc). Should I first create a table selecting fields from multiple tables then create the forms?

 

[mike60smart]

Hi

No you should not do this.

You would have a Main Form and then a Number of subforms

 

[plog]

You don't store calculated values based on values stored in other tables. If you had quantity and unit price you wouldn't store Total price, you would simply use a query to calculate it.

I really think you should read up on normalization (https://en.wikipedia.org/wiki/Database_normalization) which is the process of setting up tables. And also work through an SQL tutorial (https://www.w3schools.com/sql/) which will help you understand how to write queries.

 

[12asd]

I am creating a quotation data base with calculations. I created a form with a subform using fields from several tables (Customer, customer discount, item description, item sizes, quantity price breaks, etc). Should I first create a table selecting fields from multiple tables then create the forms?

Try creating the table using the different fields from each table, then create the form you are going to use, making sure to properly label all objects for later use. Once you finished the form create an append query to THAT table you created, use the builder function to get a value from the form and add it to a specific field in the table.

 

[isladogs]

Try creating the table using the different fields from each table, then create the form you are going to use, making sure to properly label all objects for later use. Once you finished the form create an append query to THAT table you created, use the builder function to get a value from the form and add it to a specific field in the table.

And just to confuse the OP further, I wouldn't do that either as it would result in duplicated data....unless of course you then delete the original tables.

As already stressed by others, carefully plan out what you need, design one or more tables to match your plan then create forms/subforms as apprpriate