create multiple tables from one

[Mike]

I would like to know how to make multiple tables, one for
each value of one field. i.e. One table has 50000 records
and Field1 has one of 50 values 1, 2....50. I want 50
separate tables each with associated records. Is there a
way without running 50 different make-table queries?

Thanks, Mike

 

[Phobos]

I hate to ask....but....

Why do you want to do that?

P