Prompt parameter containing two columns of data

[kramben]

I have a prompt where users can select a city from a drop down.  I want to return the latitude and longitude for the city they selected.  Lat and Long are columns in the cities table, but the parameter for that prompt can only contain one value (column) either lat or long.

Is there a work around for this?  Where users can select a city and I can return the lat and long for a distance calculation?  I feel like I am missing something here.

Thanks!
(long time reader, first time poster)