Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2008
    Posts
    1

    Red face Unanswered: access help with scout troop

    hi im designing a database for a scout troop here with an asp.net frontend and am having a problem with the database.

    im making the database accessible from the internet so that the leaders can update details from home.

    the part im having problems with is making sure that when assinging a leader to a scout/guide/cub that only the leaders who are in charge of those particular groups are available to be chosen from.

    the database has a table for scouts, leaders and groups - each have an id as a primary key

    each scout gets assigned a leader, while the leaders can be assigned to more than just one group

    im trying to make a link table so that leaders can only be assigned to a scout that is in a group they are assgned to.

    any ideas or advice on how i should go about this please??
    Attached Files Attached Files
    Last edited by jomcfall97; 08-19-08 at 17:26.

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I have two points...

    1. Why assign a leader to each scout? Shouldn't a leader/leaders just be assigned to groups and scouts are also assigned to a group? Then you can find a scout's leader by looking for their group leader.

    2. I'm not sure you should be doing this at the table level. In fact I highly doubt it. Creating Lookups/Combo boxes at the table level is always a no-no imo.... tbh, I have no idea why Microsoft introduced the silly thing, it only leads to confusion.
    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
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Quote Originally Posted by jomcfall97
    hey thanks for replying but is there anyway you could tell me how i would go about doing what i said in my query? or would you know of anywhere i could look up how to do it?
    Nope. I don't believe it can be done at the table level. Your ASP front end needs to do it I think.

    Someone else might know of a way though...
    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
  •