Mutiple values in a field based on choice from value list?

[seattleflo]

Hi,

I have a need to select an item in one field (names) from a value list and enter a cost associated with that individual in another field (costs).

I need a way to demonstrate projected vs. actual expenditures allocated for an individual's salary according to a particular budget.

What I would like to do is be able to make a selection in the names field and enter a cost in the costs field. Then, if I choose another name from the value list, I can enter a cost associated with that individual.

For example, if I select "Cynthia" I would like to enter $3,000. If I go back into the names field and select James and enter $2,000, I would like the cost field to change WHILE REMEMBERING the value for Cynthia.

Is this even possible?

(=

I have a attached a simple file to illustrate this...

Thanks so much for any help.

fields.zip

[Fitch]

Your value list could be a global field that relates to the person table. The costs field would be from the selected related person.