Creating a new table

[113deluxe]

I have a database with 4 existing tables, in the future the user wants to add new tables to the database trough a form. I want to make a form that has a button that says "create new table" or something, then the user can type in the name he wants the table to have. I also want to have a combo box where all the names of the forms are added as they are created.

I am new at this so please make it simple

Thanks

 

[IMO]

Are the column names going to be the same in every table created?

IMO

 

[113deluxe]

Yes they are going to be the same....

 

[IMO]

Maybe this link will help

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=48294&highlight=create+table

IMO

 

[113deluxe]

How do I use the code in the example? I`m not familiar to vb so I need some help. The way I want it to be is a form with a button and a texfield, in the textfield the user types the name he wants the table to have and on the click of the button the table is created.

 

[IMO]

I've never had to, or never would, let users create there own tables in a database. I'll have a proper look for you when I get a little more time.

Hope this helps for now

IMO

 

[Mile-O]

If you have to reate tables in your database then there's obviously something very wrong with your current structure.

 

[113deluxe]

Each table contains a part list for a product, If they want to add a new product with a parts list then what do I have to do??

 

[Mile-O]

Have one junction table with a ProductID and a PartsID

ProductID comes from your Product table, PartsID comes from a table that lists parts.

Make both these fields a composite key.

 

[113deluxe]

This is my first time usin access so could you please explain to me how I can do this??

 

[Mile-O]

Have a look at this:

 

[113deluxe]

Thanks for the example, it gave me some idea of how it works but this isn`t exactly how I want it to look. Lets say I have a product named LAN switch, this pruduct is made from x number of parts. I want to be able to choose the product and then view all tha parts that the productt is made from. Not everything in one table as in the example if you understand?

 

[Mile-O]

You can then query the table tblProductsToParts for the product you want and all the parts specific to that product will be returned.

 

[113deluxe]

How do I do that??I`m a complete novice so I`ve got no idea how to make a query.

 

[Mile-O]

 

[113deluxe]

That looks great. I have another question, I we look at the way you`ve made it could we go yet another step?? first choose f.ex car and then we get the part for the car, and here is the question, can we choose f.ex cd player and then get a list of the parts it`s made from??

 

[113deluxe]

Anyone???

 

[113deluxe]

Maybe I should put it another way.
we have a list over family names, we choose a family name and get a list of the family members, then we choosa a family member and get the personalia for that person.

Is this possible?? How can I do this??