CASE ERROR

[Dr.Gopala krishnam raju AMBATI]

Case (

tradename1="ACTON OR"; "AFTER FOOD";
tradename1="ALLEGRA"; "AFTER FOOD" ;
tradename1="AMPILOX CV"; "AFTER FOOD" ;
tradename1="ASPIRIN"; "AFTER FOOD" ;
tradename1="ATARAX"; "AFTER FOOD" ;
tradename1="BECONEX GX"; "AFTER FOOD";
tradename1="BESICOR"; "AFTER FOOD" ;
tradename1="BETHADOXIN 12M"; "AFTER FOOD";
tradename1="BETADINE GARGLE"; "AS REQUIRED";
tradename1="BUSCOPAN"; "AFTER FOOD" ;
tradename1="CEPODEM"; "AFTER FOOD" ;
tradename1="CEPODEM XP"; "AFTER FOOD" ;
tradename1="CETANIL-T"; "AFTER FOOD" ;
tradename1="CETANILI-TRIO"; "AFTER FOOD" ;
tradename1="CIFRAN "; "AFTER FOOD" ;
tradename1="CIFRAN CT"; "AFTER FOOD" ;
tradename1="CORBET XT"; "AFTER LUNCH" ;
tradename1="CREMAFFIN "; "AFTER FOOD";
tradename1="CROCIN"; "AFTER FOOD ;
tradename1 ="D BOSE M"; "BEFORE FOOD" ;
tradename1="DOLO"; "AFTER FOOD" ;
tradename1="DULANE"; "AT BEDTIME" ;
tradename1="DYNERGY"; "AFTER BREAKFAST";
tradename1="ECOSPRIN"; "AFTER DINNER" ;
tradename1="ETERNEX T"; "BEFORE BREAKFAST" ;
tradename1="FLAGYL"; "AFTER BREAKFAST" ;
tradename1="FLUCONAZOLE"; "AFTER DINNER" ;
tradename1="GALVUS"; "BEFORE FOOD" ;
tradename1="GLISEN "; "BEFORE FOOD" ;
tradename1="GLUFORMINI 0.5"; "AFTER FOOD" ;
tradename1="GLUFORMINI 1"; "AFTER FOOD";
tradename1="GLYCINORM"; "BEFORE FOOD" ;
tradename1="GLZ XR"; "BEFORE FOOD" ;
tradename1="HEPTAGON"; "AFTER BREAKFAST" ;
tradename1="HIFENAC P"; "AFTER BREAKFAST" ;
tradename1="HISTAC EVT"; "TWICE DAILY" ;
tradename1="HUMALOG MIX 25/75"; "TWICE DAILY";
tradename1="HUMAN MIXTARD 30/70"; "TWICE DAILY";
tradename1="LANTUS"; "ONCE DAILY";
tradename1="LEVOCET"; "TWICE DAILY" ;
tradename1="LUMIA"; "ONCE WEEKLY";
tradename1="LYRICA"; "ONCE DAILY" ;
tradename1="MECALFA"; "ONCE DAILY";
tradename1="METASPRAY"; "ONCE DAILY";
tradename1="NEFROZON"; "TWICE DAILY" ;
tradename1="NOVOMIV 30/70"; "TWICE DAILY";
tradename1="ONDERO"; "ONCE DAILY" ;
tradename1="PANTOCID"; "ONCE DAILY" ;
tradename1="RANTAC"; "TWICE DAILY" ;
tradename1="RIAX"; "ONCE DAILY" ;
tradename1="ROSAVE"; "ONCE DAILY" ;
tradename1="ROSAVE F"; "ONCE DAILY" ;
tradename1="TAXIM OF"; "TWICE DAILY" ;
tradename1="TELLZY"; "ONCE DAILY" ;
tradename1="TELLZY AM"; "ONCE DAILY" ;
tradename1="TELLZY CH"; "ONCE DAILY" ;
tradename1="TELLZY H"; "ONCE DAILY" ;
tradename1="TELSARTAN AM"; "ONCE DAILY" ;
tradename1="TENLIP"; "ONCE DAILY" ;
tradename1="TEPID SPONGING";"AS REQUIRED";
tradename1="THYRONORM"; "ONCE DAILY" ;
tradename1="TRYPTOMER"; "ONCE DAILY" ;
tradename1="ZENTEL"; "ONCE DAILY" ;
tradename1="ZIBOSE M"; "THRICE DAILY" ;
tradename1="ZITELMI"; "ONCE DAILY" ;
tradename1="ZOLE OF"; "TWICE DAILY";
tradename1="MET XL";"ONCE DAILY";
)

I am defining a field with above script i am getting error that " the specified field cannot be found " after error going here as shown in pic ?? where am i going wrong sum1 pls guide pls

Edited October 8, 2016 by Dr.Gopala krishnam raju AMBATI

[comment]

Have a look at the line above:

tradename1="CROCIN"; "AFTER FOOD ;

You are missing the closing quote after "AFTER FOOD.

 

Note:
This calculation should not exist at all. The names of the drugs and the instructions for their use are data. They should be stored in a Drugs table, and retrieved from there via a relationship.

 

 

Edited October 8, 2016 by comment

[Dr.Gopala krishnam raju AMBATI]

  On 10/8/2016 at 7:18 AM, comment said:

Note:

 

This calculation should not exist at all. The names of the drugs and the instructions for their use are data. They should be stored in a Drugs table, and retrieved from there via a relationship.

Expand  

when something missing it should jump there but its jumping to next line ????

its not accepting after ur suggested rectification i removed all the fields starting with D to the bottom its working

understood sir  , but i am setting auto calculation text fields for faster predefined disease prescriptions and print

[comment]

  On 10/8/2016 at 7:47 AM, Dr.Gopala krishnam raju AMBATI said:

but i am setting auto calculation text fields for faster predefined disease prescriptions and print

Expand  

<shrug>

[Dr.Gopala krishnam raju AMBATI]

  i will show u shortly comment

  On 10/8/2016 at 7:57 AM, comment said:

<shrug>

Expand  

1st image has nil medications showing urti adult as soon as i change it to apd medications appear filling everything   blink fast finally comment everything in place without any relationships

Edited October 8, 2016 by Dr.Gopala krishnam raju AMBATI

[comment]

  On 10/8/2016 at 7:59 AM, Dr.Gopala krishnam raju AMBATI said:

everything in place without any relationships

Expand  

FileMaker is a relational database. It functions best when the solution is organized according to the relational model of data management. "Without any relationships" is not something to be proud of. On the contrary, it shows you're not using the tool in the optimal way.

[Dr.Gopala krishnam raju AMBATI]

comment i changed my idea of manual entry as u said to relational entry thanks for idea now its more faster and easier to edit

Edited October 8, 2016 by Dr.Gopala krishnam raju AMBATI