Creating Tables & Records

[Milan]

Sorry I have had to re-posted this one!!!

Hi People,

I have a table which has the following fields:

CreateFieldNm , startvalue, endvalue
TEST1 1 56
TEST2 57 120
TEST3 121 245

basically what needs to happend, is when user enter the createfield name , start and endvalues. the code will then go to a another table create a field name called TEST1 and will set the data type as a integer, and will create 56 records which will start from 1 and will end 56. something like:

TEST1
1
2
3
4
so on.,.. to 56

it will then do the same for the next record, newfield, sametable as before, but newfield called TEST2 , and records from 57 to 120. and on to the next record.

My brain is telling me to use the tabledef object, using the createfield method?. Any ideas on how i can do the above?

Would really appreciate some help on this one please!


Thanks

 

[Shadez]

hmm that seems like a lot of work, its not going to be very efficient.

ur table will end up looking like this

Test1,test2,test3,test4,test5,
1         
1
1
           1
           1
           1
                    1
                    1
                    1
                              1
                              1
                              1
                                        1
                                        1
                                        1

and so on look at all the wasted space.

How long are u storing the data? is it tempory.

 

[AncientOne]

I think Milan has this sort of thing in mind...?

 

[Milan]

Hey Thanks

Sorry for not getting back to you earlier!,

Thank you very much for doing that!! Works A Treat!!. Where would we be without you people! It is always nice to have a fall back option when you are stuck!.


Thanks Again!

 

[Milan]

I'm not storing the data for long in the table, amongst the process the table will get deleted, and re-created. But for the purposes of this exercise is ideal!!!.

Cheers!!!