Very simple question!

[fiddley]

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

[RuralGuy]

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.

[fiddley]

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!