Unanswered: help a newbie trying to create a simple db?
I'm trying to create a database that seemed, when I had the idea two weeks ago, like it would be fairly simple. I have two tables, one called Characters (it holds their name, race, and gender) and one called Conversations (it uses lookups to grab the characters' info from the first table, as well as text fields to enter the subjects). I wanted to create a query or a report or something that would use these two tables to spit out a chart that would list the conversation number, each of the participants, the subjects, and each of the participants' gender and races.
It seems like it should be a fairly simple extension of what loads of other databases do, but I can't make any headway at all. Can anyone point me to a tutorial or a sample database that could help me figure this out? I am so very new to this it's embarrassing, I'd really appreciate any help at all!
As for what I've tried . . . a little bit of everything, most of which I didn't really understand. I have tried creating a report but when I use a multiple values field, like I am in the screencaps, it only shows the gender/race of the first character. If I provide separate fields for each character, the report is overflowing with blank columns and I can't figure out how to get rid of them.
What I was hoping to be able to do is enter the characters and have the application check their genders/races and tell me whether the conversation is men only, women only, or men and women, etc. Is that even possible?