Dynamic refresh of value lists

[kminov]

Hi,

I have the following problem:

I have a database of companies, some of which are checked as holdings. I need to define a value list, which will display only those companies, that have been marked as "holding" with a checkbox (i.e. the checkbox field is set to "1"). I have found a couple of ways to do that, but when I assign a company to a holding and after change the name of the holding company, the value in the assigned record stays the same. So I need to have the value list update the records when I change the name of the company I have assigned as "holding". I have managed to get it working with the company ID, but I can't make it show the company name, and not the ID, which is useless for the end users.

Any ideas?

thanks