[mart-dev] Constructing URL using the value from another attribute (is this possible?)

[Allan Kamau]

Hi all,

I am trying to make use of URL hyperlink in the values of a given 
attribute (field), but the hyperlink will contain unique integer value 
stored in some other attribute (or field) in the same table, is this 
possible and how can I achieve it.

Let me explain why it is so. The field to contain the hyperlinks 
displays some numeric value in my case a count so let's call this field 
the count field. This field contains values such as '2' or '7' or even 
NULL (this means the values are not unique) for this field. In another 
column (hidden from user) are unique ids for each row. I would like to 
make use of these unique values in the hyperlinks of the 'count' field.


The unique ids as tied to some child tables which may contain several 
records for each unique id value, it is these records I would like to 
display once a user clicks on the count value of the 'count' field.


Allan.