I want to add a url link to a record so my clients can click and open another webpage and view relevant data.

The webpage I want to direct them to has the same basic url with a unique 4 digit file number for each set of records.

So let say the url to be used is "www.myrecords.com/file=". I then  need to add "#3245" as the unique file# to give a link of www.myrecords.com/file=#3245" and add the url link name "Click for records".

So I add a url field with link name option selected. I add a second field to add the file #. I believe I can add a statement under the second field "On user input" which would combine the url with the file# and inout that into the url field and enter the "Click for records" as the link name.

Can anyone give me a sample code?

Thanks

Arlan