Maybe more explanation:
I already have a table for the meeting. I want to create a table on the fly, when the meeting is entered by user, to have fields to hold the userid's of the participants that want to attend the meeting.
Sorry if I am not explaining well.
already have meeting tbl (meetingid, meetingname, maxparticipants, maxreserveparticipants, date, location ect...
already have user tbl ( userid, fname, lname, email)
what I want is to use the maxparticipants and maxreserveparticipant numbers to create a table that holds the userid's of the people who want to sign up. maxpart and maxres numbers may be different for each meeting based on user input.
participant table (meetingid, participant1, participant2 until == maxparticipants)
I want this table/s to be created when the user creates the meeting.
Hope this makes sense.