I have a form where the combo box list the server name and number which pulls from the tblservers (not sure this is relevant)
ID | ServerName
1 | s1
2 | s2
3 | s3
etc...
The combobox shows s1, s2, s3, etc.
However,
I have written an expression to create a link in a text field to the correct server page. the only problem is, it is pulling the ID number and not the server name.
=IIf([JobServerID_FK]<>"","http://" & [JobServerID_FK] & ":" & [TPNumber] & "/mobiledoc/ScriptServlet","No Server")
http://5:9064/mobiledoc/ScriptServlet
I need to see s1, s2, or s3 where the 5 is showing
SORRY HIT THE POST BUTTON PREMATURELY...
Do I need to add the server name to my query that the form is pulling from?