Auto enter base on multiple drop down entries

[Linda MacMillan]

I have three related drop down menues whic allow someone to classify the type a file within our filing system. Each classification has a unique classification number which forms the first part of the file number. I want to auto enter this classification number when someone selects all three elements of from the drop downs

I've tried lookup but it only works with the first find in a single list

I've tried autoenter with a calculation using e.g. case, but can't get that to work either.

Any ideas?

Thanks

Linda

[Anuviel]

Something like this? (see file)

* Note that the auto-enter field will stay empty if any of the value lists fields does not have value in it.

Test0002.zip

Edited October 17, 2008 by Guest
Added *