Auto Value List

[phunkidude]

I am trying to have a Value List be auto-generated based on data entered in another field. This is my problem:

I am making an Employee database for which each employee has a job title which is selected from a Value List (for example Account Manager).

I also have a Contacts (or Companies) database and an Account Manager is assigned to each of those Contacts. I would like to assign the Account Manager from a Value List but I would like this Value List be generated based on whether an employee is assigned as an Account Manager (or not) so as new employees are added (or terminated) and assigned as Account Managers the Value List in Contacts will update.

I hope I explained that clearly enough.

[bcooney]

I think I understand, so let me restate:

I have an Employee table. Some employees are of type "Account Manager." On my Companies form, I assign employees as Account Managers. Therefore, I would like to select from a conditional value list of just the employees that are Account Managers.

Here's a demo how. On the Company layout, I've layered two fields. The bottom layer is the popup menu to Acct Managers, the top is a field that shows the name. If you change an employee from Account Mgr to another title, then you need the top field to keep displaying the name of the employee that was assigned as Account Manager, even though they are no longer an Account Manager.

Topic_194040.zip

[phunkidude]

Barbara,

that's exactly what I was looking to do. I just have to figure out how you did it now.

Thanks for your help!

Sean

[Tony O]

I have a similar problem, and can't see how your solution fits it - maybe it's not so similar!

Anyway, it's like this - I have two fields, stage and zone. IThere are 3 stages - C, A, and K. each stage has different valid values. C has B, B1, B2.

A has P1, P2 and P3. K has O, Y, and R.

I would like - when the user is inputting, entering a "C" in stage will give a value list in zone showing only the values B, B1 and B2.

I set up 4 value lists; C, A, K and Blank with the appropriate values (Blank got none). I then set the zone field to a drop down list set to default to Blank.

My next thought was to have the zone field auto-populate itself by calculation based on the stage input, using ValueListItems ( fileName ; valueList ) in an if/then statement. This works, but sets the whole of the value list in the field (you can't choose one value, in other words; you get 'em all). which made sense as soon as I did it, dur!

So, any idea how else to accomplish this? TIA _ Tony

Edited March 21, 2008 by Guest

[mr_vodka]

Do an advanced search for +conditional +valuelist and you will come across many examples.

[Tony O]

Awesome. I like this one best. Thanks!

Topic 174320