September 10, 200718 yr 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
September 12, 200718 yr Your value list could be a global field that relates to the person table. The costs field would be from the selected related person.
Create an account or sign in to comment