Hi,
I've a table tbl_Workshop that has columns ID,title,date,trainerID_1,trainerID_2,trainerID_3....and so on...
for the number of trainerID columns it is based on the users selection. It could be one or two or three and so forth.
How to deal with this issue, when I cant decide the number for the trainerIDs columns to be created in my table tbl_Workshop.
Also trainerID is a FK.
Go to the complete details ...