I am a newbie both to databases and this particular method of creating them.

I have made a form with the main primary field being the identifying name of an item. What I would like is that the name is clickable to an associated URL path, if there is no link I would still like to see the identifying name. I have used the URL field but it doesn't like a blank URL field and if I use just http:// it brings up a blank page (not very elegant). The important part of the URL field for me is the link name not the actual URL, does anyone know if there is a way of adding either a special null address or something that will allow me to have my primary field which allows me to either link a URL to the the primary single line name field or not

I hope that is clear