I see a lot of posts about drilldowns to URL. But, unless I missed something, I don't see one which fits this need.

What's it take to drill down to a URL which is specified in a DB or DEFINEd field? Consider the following code:

DEFINE FILE CAR
MyURL/A128 = DECODE COUNTRY (ENGLAND 'http://IBI.com' FRANCE 'http://WWW.GOOGLE.COM' ELSE 'http://WWW.YAHOO.COM') ;
Video/A5='Video' ;
END
TABLE FILE CAR
SUM Video MyURL RETAIL_COST DEALER_COST BY COUNTRY
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN, SQUEEZE=ON, ORIENTATION=PORTRAIT, GRID=OFF, FONT='ARIAL', SIZE=9,$
TYPE=DATA, COLUMN=Video, URL=MyURL,$
TYPE=DATA, COLUMN=MyURL, URL=MyURL,$
ENDSTYLE
END

Or, better yet, from the "Video" field.

This message has been edited. Last edited by: Doug,

Your concept is sound, but you need to build the complete hotlink tag in your DEFINE field. Instead of

http://www.yahoo.com

you need to create

MyURL/A128 = '<a href="http://www.yahoo.com" > Go to Yahoo </a>'  

That was a heck of a thing for me to forget, the tags and anchors. Afterall, now that I think about it, I've done this before. So, I'll share this code:

DEFINE FILE CAR
LinkID/A128 = DECODE COUNTRY (ENGLAND 'IBI.com' FRANCE 'Google.com' JAPAN 'Yahoo.com' ELSE 'TheFamiLee.net/DEL') ;
YourLink/A512 = '<' || 'a href="http://www.' || LinkID || '">' || LinkID || '</a>';
END
TABLE FILE CAR
SUM YourLink AS 'Your Link' RETAIL_COST AS 'Retail' DEALER_COST AS 'Dealer' BY COUNTRY NOPRINT
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
-*ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN, SQUEEZE=ON, ORIENTATION=PORTRAIT, GRID=OFF, FONT='ARIAL', SIZE=9,$
TYPE=DATA, COLUMN=Video, URL=YourLink,$
TYPE=DATA, COLUMN=YourLink, URL=YourLink,$
ENDSTYLE
END