Neville310 Posted March 7, 2005 Share Posted March 7, 2005 I am working on an interface solution and have a question about calculated fields. My database has calculated fields for displaying tab graphics and the related labels. These calculated fields do not seem to update automatically. In fact, their behavior is not predictable; thus they are broken. The situation has me scratching my head as I have elementary knowledge about these intricate calculation fields. Upon reviewing another interface example, the calculated fields have both check boxes under “Storage Options.†Select a calculation field, then [Options]; then [storage Options]. Has A Checkmark Use global storage (one value for all records) Has A Checkmark Do not store calculation results – recalculate when needed The calculation script is correct since I copied it from the example file. The only difference between my calculated fields and the example is the “Storage Options.†Mine has “Use Global Storage†checked while the example has both. Apparently, Filemaker does not allow me to select both options; it deselect one when you select the second option. Does this behavior sound normal? How does one select Global storage and recalculate at the same time? I tried re-selecting both on the example file and Filemaker did allow me to re-select both options again. How does the calculated fields act in Find Mode? Do my graphics disappear? Let me know if you have any additional insight on my situation. Link to comment Share on other sites More sharing options...
Maarten Witberg Posted March 7, 2005 Share Posted March 7, 2005 Could you point me to that example file? kjoe Link to comment Share on other sites More sharing options...
CobaltSky Posted March 9, 2005 Share Posted March 9, 2005 This is a duplicate thread. There is another one just like it at: http://www.maclane.com/ubbthreads/showflat.php?Cat=0&Number=497873&an=0&page=0#497873 Please don't post duplicates, Neville (and anyone else who was thinking of doing so...). Link to comment Share on other sites More sharing options...
gss Posted March 17, 2005 Share Posted March 17, 2005 HI since we are on calculating fields.. I have another newbie question... I have aprice file in a fixed format: sku(6)descr(12)retprice(6)wholeprice(6) as one text string... "PD3456PRODDESCRIPT001899002499" HOW do I import into the database? (I went the excel route) I'd rather import it directly into foxpro And the other question is once I get the price as a text string of say "001899" how do I turn it into 18.99 number? Do I divide the number by 100 is that a calcuated field area? Thanks Link to comment Share on other sites More sharing options...
Ender Posted March 17, 2005 Share Posted March 17, 2005 Off topic. Your FMForums thread has been answered. Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Archived
This topic is now archived and is closed to further replies.