If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Multiple Field Entries in Report
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! |
#2
|
|||
|
|||
Multiple Field Entries in Report
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. -- KARL DEWEY Build a little - Test a little "emma" wrote: 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! |
#3
|
|||
|
|||
Multiple Field Entries in Report
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! "KARL DEWEY" wrote: 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. -- KARL DEWEY Build a little - Test a little "emma" wrote: 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! |
Thread Tools | |
Display Modes | |
|
|