After lookup display url link
I have a customer form and a preferred vendor table. The customer chooses a preferred vendor and I display the vendors address and phone number in text fields on the customer form. Works perfectly!
I want to also show the vendors website address which is stored in the preferred vendor table. I tried using a url field on the customers form but nothing was populated. I then tried a string field which worked but the address starts with <a href= " and ends with target = "_blank">Link Name</a>
This is confusing to the customer.
Is there a way to display the vendor website address on the customer form so that it is a hyperlink?
Herb Wexler