Create Table with fields defined in another table

[ferrisbb]

I am kind of new to Access, an old dbase programmer. I need to create a table(b) using the data from another table(a). The first table(a) has 2 fields #1-name, and #2-number. If the data in field #1 is "Smith" and the data in field #2 is "5", I need table(b) to have fields #1 - Smith1, #2 - Smith2, #3 - Smith3, #4 - Smith4 and #5 - Smith5.
So basically the first table(a) has the 1 - field name and 2 - how many fields with that name need to be created. I need to use the name+number in the field of the second file i.e. Smith3. Of course table(a) has many records each with different names and numbers of fields.

The idea here is that I can go into a form, edit the number associated with the field name and generate a new table with the required number of fields for each name. I will then have another form to input the data into the new table. I am sure this second form will be my next posted question.

Any help would be appreciated.

 

[Darrylles]

hi,

Look at the post 3 or 4 below yours:

'Copy 2 tables to 1' by Donlapre.

Same issue.

Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk