Multiple Field Entries in Report

[emma]

Hey,
Hopefully this isn't too stupid a query, but I'm trying to make a database
to study for anatomy. Now one of the things this involves is muscle
attachments and actions. Obviously I have the fields of Muscle and Action for
example, but many muscles have more than one action. However, if I enter more
than one action in the cell, only the first will be displayed on the report,
leaving me with incomplete data.
The only way around this that I have found is to enter the muscle numerous
times, but this will become VERY arduous.
I'm sorry for rambling about muscles, and if what I'm asking is confusing,
but if anyone can help out, it'd be greatly appreciated.
Thanks!

 

[KARL DEWEY]

You need two tables set up in a one-to-many relationship.
Muscle ---
MuscID - autonumber - primary key
Name - text

Action ---
ActionID - autonumber - primary key
MuscID - number - integer - foreign key
Action - text

In your report set the Hide Duplicates property of the muscle name to Yes
to not display repetitions of the name.

 

[emma]

I see. Thanks, I'm pretty sure I figured that out. Bit fiddley this program.
Might be better to do it the long way. I might learn more!
Thanks a lot anyway!