URL behind Static Field obtained from DB

Running SJSC2.1 on XP w/Derby

I have an application which has a dropdown, a table and some static fields

Two static fields i want to be hyperlinks (go to another unique page) based on the db query. The field is populated correctly from the query how do I associate a specific url with the current value of the static field? The url is in the db also. (fields: report and reportURL)

The url is specific to whatever value is returned from the query.

For example:

values a & b are returned from the query.. value a should go to page 11 value B should go to page 12

the user selects another option from the dropdown list and values M and N are displayed, M should go to page 44 when clicked and N should go to page 45 when clicked.

How to do this?

Thanks

[809 byte] By [SummerWinea] at [2007-11-27 0:37:17]