table a; -- contains some categories
table b; -- =m:n relationship table for "a" and "c"
feature class c;
table d_*; --contains all data from "b" related to a single category (row) of "a"


foreach row in a
{
 create table d_*;
}