Calc: can this be done?

[RET]

I would like to know How and if I can create a calc. That will auto enter different Info by choosing different categories.

Example: I have a calc. that will enter the name when the code is chosen.

Case(

fall even Year = "AD1"," LAYOUT 1",

fall even Year = "AD11","NEW BUSINESS/PRESENT",

fall even Year = "AD12","GOBAL ADVERTISING",

fall even Year = "AD15","ADVANCED CAMPAIGNS",

fall even Year = "AD17","TV CONCEPTS 3",

fall even Year = "AD19","TV CONCEPTS 4",

fall even Year = "AD2","BRANDS & BRANDING",

"")

But now I want to use a different set of calculations for each year, But have it enter in the Course name as well as having a different set of Value lists to go with them for fall even year, just by choosing a new year from a different field.

If you have any idea please let me know?

RET

[Chuck]

Could you give us an example?

[Vaughan]

Autoenter only works when the record is first created, and never again. It sounds like you need a script and a global field or two...