Page 1 of 1

'Evaporating' Fields

PostPosted: Wed Sep 14, 2005 12:00 pm
by Leoff
..well, there must be a simple solution to this that I am just missing...help is appreciated~!

I'm in FM7 on a PC. In one table I have a text calculation field called 'Doctor_Phone' using;
Case(not IsEmpty(Doctor_officephone) and Length(Doctor_officephone) >=10;
Trim(Let(phone = Filter(Doctor_officephone;"0123456789Xx");"(" & Left(phone;3) &
") " & Middle(phone;4;3) & "-" & Middle(phone;7;4) & " " & Middle(phone;11; 100)));Doctor_officephone)
and the indexing is minimal.

I am attempting to bring this phone number into another table (all other info from the doctor table comes in fine) with a lookup. But, when the field is created and I look in 'Field Data' all I see is 'Graphic reporting'. The field information seems to evaporate...

Surely I am missing a key element here, please help! Much thanks...

Leoff~ :?: :roll:

PostPosted: Thu Sep 15, 2005 4:14 am
by John Sindelar
I don't think this is about your calc's definition, provided the calc displays we'll in the doctor table. Sounds like something is wrong with your lookup- you may have selected the wrong relationship for the lookup.

PostPosted: Thu Sep 15, 2005 11:10 am
by Leoff
...nope, doesn't seem to be that! I have checked and double checked...I have copied other lookup fields from the same relationship that DO work, changed the field only and still no success! Too strange...

I am at a loss... :(

Thanks for your help...

Leoff

PostPosted: Thu Sep 15, 2005 11:12 am
by John Sindelar
Feel free to email me the file(s) and I'll take a look. (john at seedcode.com_