I have tblCategory and tblExercise. The data in tblExercise can sometimes match with more than one record in tbCategory. When inputting data into tblExercise how can I choose to have that stored under more than one field in tblCategory?
Example:
tblCategory: Arms
tblExercise: TRX Biceps Curls
so TRX Biceps Curls can also be under
tblCategory: TRX
Right now I have to input TRX Biceps Curls under Categories Arms and TRX. Very time consuming. I hope there is an easier method.