hi all,

i need help to divide my table to 24 tables

my table have filed (area) from 1 to 14, and another filed (resident)
from 1 to 2,

USE RIS_RANDOMS
if area=1 or 2 or 3 and resident="1"
COPY STRU TO AmmanA
endif

if area=1 or 2 or 3 and resident="2"
COPY STRU TO AmmanR
endif

if area=4  and resident="1"
 COPY STRU TO ZarqA
ENDIF

if area=4  and resident="2"
 COPY STRU TO ZarqR
ENDIF
....
.
.
.
if area=14  and resident="1"
 COPY STRU TO AqabA
ENDIF

if area=14  and resident="2"
 COPY STRU TO AqabR
ENDIF

thanks