Currently i am designing database for Portal.
On Portal screen, There are some fields which are having multiselection facility
1) professional is one of the field having
are values, User can have more then one profession.
Same type of 30 fields are available on single screen.
So the storage for single such field i have to created new table for multiple values storage.
For that total 30 child table get created for a single screen.
Can any one help me, how do i manage this in minimum tables?