Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2009
    Posts
    2

    Unhappy Very simple question!

    Hey there, hope you'll forgive me for asking what I am sure is a very simple thing to you, but I have spent a day trying to do this and it's driving me up the wall!



    I'm an administrator rather than a programmer, but I'm trying to save my employer a few bob by knocking together a simple asset DB. I've got an awesome table design sorted, but am missing the key knowledge to manipulate the data.

    All I'm trying to do is change a Label caption based on what a user selects in a listbox.

    Simplified, say there's two tables, computers and people:

    Computers
    ComputerID,ComputerName,PersonID

    People
    PersonID, Name

    I have a listbox with all the computer names, and I want to display a label with the name of the person who is responsible for the computer selected.

    When you've stopped laughing I wonder if anyone would be so kind as to point me in the right direction?

    Any and all advice gratefully accepted!

    Cheers,

    Mark

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You can create a query that joins the two tables on the PersonID field and then it will be as if all of the fields are in the same table. Does that help? Your query can be the RowSource of the ListBox.

  3. #3
    Join Date
    Apr 2009
    Posts
    2
    Right cool, think we're getting somewhere! Thankyou!

    I have a problem with my SQL now (!) so off to do some research.

    I'm thinking maybe we should have just bought a package, but this is actually fun!

    Cheers!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Help with a simple query
    By JohnnyO in forum Queries
    Replies: 1
    Last Post: 02-11-2009, 09:43 PM
  2. Please help w/ simple languages db
    By TalentNation.net in forum Database Design
    Replies: 0
    Last Post: 01-23-2009, 09:11 AM
  3. Simple but hard question
    By andymok in forum Reports
    Replies: 1
    Last Post: 09-20-2007, 09:19 AM
  4. Should be simple Query Question
    By brj1 in forum Queries
    Replies: 2
    Last Post: 03-04-2006, 01:11 PM
  5. Probably a simple report question
    By gmurrie in forum Reports
    Replies: 1
    Last Post: 12-28-2005, 09:19 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums