'Evaporating' Fields

General Information about upcoming products, upgrades, etc.
Posts: 9
Joined: Tue Aug 17, 2004 12:10 pm
Location: Orlando
PostPosted: Wed Sep 14, 2005 12:00 pm
..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:
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Thu Sep 15, 2005 4:14 am
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.
John Sindelar
SeedCode
Posts: 9
Joined: Tue Aug 17, 2004 12:10 pm
Location: Orlando
PostPosted: Thu Sep 15, 2005 11:10 am
...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
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Thu Sep 15, 2005 11:12 am
Feel free to email me the file(s) and I'll take a look. (john at seedcode.com_
John Sindelar
SeedCode

Return to FileMaker Products (General)

Who is online

Users browsing this forum: No registered users and 2 guests

cron
(855) SEEDCODE
[email protected]
Follow us: