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