Results 1 to 4 of 4
  1. #1
    Join Date
    May 2009
    Posts
    2

    Red face Unanswered: help a newbie trying to create a simple db?

    Help, please!

    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!

    --Ceresi

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Sounds to me like all you need is to create a report based on a query that joins your tables together.

    Without more clarity on your table design, or what you've tried, it's hard to help you much further.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    May 2009
    Posts
    2
    I've uploaded two screencaps of my tables, if you'd like me to upload the entire db I can do that, too. Here they are:

    first

    second

    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?

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Everything is possible, depends on how much time you want to throw at it.

    Sorry, but I have zero experience in using multiple value fields. I think they are a recipe for disaster.

    I would have the report list the characters by way of a subreport. An episode would relate to a table, perhaps "cast", that was a set of records of characters and roles.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •