Choosing values of a field with drop-down menu.

[kikonas]

Hi.
New in access(and this forum).
Let's say that I have made a table about clients with fields:"name" and "money".
I want to have (in another "table") the possibility to choose through a drop-down menu from the values of e.g. "name" and then to the next cell make appear the respective value of "salary" or a mathematical expression of it(e.g. "salary"+500).
I'm looking for a general guiding(e.g. the second "table" should be a table,a form, a query?)


Thanks in advance.

p.s.even a link in a tutorial answering to this?

[hertfordkc]

One of them might work, unless your task is more complex than I see in your question.
Just do a search on Access listbox and you'll get all the examples you need.

If this solves your problem, please mark the post as solved by using the thread tools.

[kikonas]

Thanks. Do you have any link for examples for listbox and combobox?

[hertfordkc]

www.fontstuff.com/access/acctut11.htm

www.youtube.com/watch?v=AQrCO9-_QOQ

http://office.microsoft.com/en-ca/ac...005188485.aspx

[kikonas]

Thanks...