Table relationship design

[wschlichtman]

I would like to create a database that associates a particular physical
exercise to the muscles that are being worked, and vice-versa.

I.e., if I select an exercise from a dropdown box, the database would
display the muscle(s) that are being developed from the exercise. Also, if I
select a muscle group to develop, the application would display the exercises
that could be used to work that particular muscle.

E.g.:

Seleted Exercise: Lat pulldown
Muscles worked: Latissimus Dorsi, Biceps

Selected Muscle: Biceps
Exercises: Lat pulldown, Bicep curl, Dumbbell preacher curl, etc.

Any table/relationship design help would be greatly appreciated.

 

[Duane Hookom]

It might help to think of this in terms of Northwind which has Orders, Order
Details, and Products. Your physical Exercise is the Orders table and each
muscle is a Product. The Order Details allows an Order (Excercise) to relate
to multiple Products (Muscles). Your OrderDetails would be an ExerciseMuscle
table with one records per Exercise per Muscle.