Create table with info found in form

[Fluffy]

Hello,


I have a form with information about hubs. When I enter the information of a new hub, and push the 'Save hub' button, next to saving all the info I want a new table to be created.

I want the table to have the name of the hub (txtHubName on the form) and I want the number of fields in this table to be equal to the amount of outlets the hub has (intHubOutlets on the form). The datatype of these fields should be boolean. And their value should be 'no' (as in 'no, their's nothing connected to this outlet').

For instance: HU-0001 has 4 outlets. Name of the table should then be HU-0001 and the fields should be outlet1 to outlet4.

[This way I hope to keep track of the outlets that other equipment use. Like PC-0001 is connected to HU-0001, outlet1 (which then has the 'yes' value instead of 'no')]

So, in short: it's the creation of the table with it's fields that I have problems with. I've looked up some SQL code, but it just can't get it to work.


Any help would be welcome,
Oswald

 

[Rich]

I suggest you read some articles here on normalisation first.
You don't need a new table for each hub.

One table for hub and one table for outlets is all you need. With a one to many relationship between them.
Also read on working with forms and subforms