Adding same data to different field within another table.

[bishop0071]

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.

[June7]

Data structure doesn't sound normalized. If you want to provide for analysis, follow instructions at bottom of my post.

Why is this data entry time consuming, what is it for?

[bishop0071]

I can have for example, TRX Pushups. I can put that under Category Chest, TRX, or Core. So I would have to type in TRX Pushups in each one of those categories. Having it under those categories would help because if I wanted to look just for TRX exercises I can pull up TRX and it only shows me those exercises. Same goes for if I wanted just Chest exercises or Core exercises.

[June7]

What if you wanted to search for Pushups and find all the categories Pushups is associated with? Would be possible with your table but a little more complicated than with normalized structure.

Normalized structure would be:

tblExercisesCategories
ExerciseID
ExerciseCategory
ExerciseName

Regardless of structure, might speed up by using combobox to help populate fields. Combobox can have RowSource that is a static list or can have table source for the list items.