Topic: Calculated Field Problem
I'm having trouble with a calculated field
-
I have a Users table with FirstName, LastName....etc.
-
I created a Calculated field (FullName) with the following code:
tblUsers.FirstName || " " || tblUsers.LastName
-
I also tried using this code from one of the sample applications:
ifnull(firstname,'')||' '||ifnull(lastname,'')
-
However when I try to use FullName on my forms, it only works on some forms, but not others
-
On the forms where it doesn't work I get an error message saying that tblUsers.FirstName doesn't exist.
-
I configured everything the same on all forms, and as I said it works on some but not all.
-
I can put the FirstName and LastName in separate text boxes, but it doesn't look very good with extra spacing between the 2 names.
-
Maybe there's a better way to get these names together on a form?
-
Any thoughts will be appreciated.
-
Thanks, Frank