Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2006
    Posts
    559

    Unanswered: Need to inquire if I'm doing this right...

    Ok, so I just need to see if I'm doing this correctly.

    I have a form, where users can enter like a new country into the Database. But what I'm trying to do is add a "Continent ID" and "Continent" from another table so that they can pick which continent the country belongs in and save it to the table. (ie: if they pick like "France", they can then select "Western Europe" and it'll add it to the table).

    However, the "Continent" is in another table. I figure to just do it in a query, correct?

    It would be:

    They type in the Country name. And on the same form, a pulldown selects the list of continents from the tblContinent for them to add it, then the Continent is updated in the tblCountry for that particular country.

    Yes? No? Or is there and easier way?

  2. #2
    Join Date
    May 2008
    Location
    Raleigh, NC
    Posts
    151

    Correct....

    The pull-down would have a query as its recordsource going against the correct table. You would then need a mechanism, a button probably, to grab the values in the pull-down along with the country they typed in and then insert it into the table.

    Hope that helps.

    Stu
    --If its free, take it for what its worth!

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    They type in the Country name and on the same form, a pulldown (combo box) selects the continent from the list of continents in the tblContinent, then the record is added to the tblCountry table, complete with both the new country name and the ID for the particular continent.
    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

  4. #4
    Join Date
    Aug 2006
    Posts
    559
    Thanks StarTrekker and Stu. I was thinking about the way you said to do it (trek) and that was what was in my head, just probably didn't come out the same on here. Dang dilexia is kickin in, or it's the alzheimers.

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Well you spelled alzheimers pretty well so I'd say that it's not dyslexia
    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
  •