Autopopulate field based on value list entry; calculation help needed

[Rich S]

I'm having a severe "senior moment" that's lasting all day today and may drag on throughout 2007 at this rate. Ugh. So, if you can help me solve the following I'd be immensely grateful.

(Refer to the attached file, please.)

What I want to do is in the Reports layout/table, select an identifier (ex. PHX) so the field beneath it, City, will autpopulate with "Phoenix, AZ"; it would autopopulate this field from its related City field in the table/layout, Value Lists.

Why I can't get it to work, well...I'm down to two brain cells and counting.

Thanks in advance for your help!

Rich

pee ess: This calculation will eventually end up in a run-time solution, hence the reason why I'm not using multiple Case statements for the above.

test.zip

Edited January 5, 2007 by Guest
forum can't use quotes in subject

[mr_vodka]

You currently have the relationship keyed from report_number to fk_Report_Number. fk_Report_Number has an auto entry for what it seems to be a primary ID for the value list entries.

Are you trying to select a header for your reports? If so you should use a header part section and use a global text field there with your popup menu. There should be a relationship keyed from this global field (lets call it gAirportCode) to the Identifier field of the Value lists table. Then reference the related city field.

[Rich S]

Thank you, I'll give it a try!

(Sorry for the delay in responding--I've been out-of-town.)