Table relationship design

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.

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.

--
Duane Hookom
MS Access MVP


"wschlichtman" wrote in message
...
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.