Dr.L

Seems simple, will enter this later and let you know! Much thanks... L~

How can I invoke a script within a script after a found set is empty...? Much thanks all! L~

Help! No assistance here, no one has any answers as usual? Doesn't anyone know what's occurring here? Dr.L

Nice...NOW I see it! Sorry, must have been a mind block for some reason! Perfect now...much thanks for "keeping it simple". The K.I.S.S. theory is much better sometimes. And, MUCh thanks for your patience and persistance...great help! Dr.L

Couldn't open it...I'm on a PC...keeps saying it's not modifiable and the acction cannot be performed...

I am SO sorry, guess I'm missing something here as this is just not functioning now. I've gone under 'Format' and to 'Conditional Format'...placed in the given formula. How can I choose and select two various colors in the selection box after I enter the formula? There is choice for only one color at a time...what am I missing? The case function is not overriding the box selection and doesn't function without some selection it seems... Thanks... Dr.L

I'm on FM 11Pro...usually we drag and drop or copy into a container field...all works well with a PDF and/or JPG... Dr. L

I am housing Word documents in a container field. However, when I try to open them there is a problem and something funky happens. Am I doing somethin wrong here...? Thanks... Dr.L

...thanks all, but can I use this formula in the field for "Conditioning Formatting"? Or, am I better served to use it in the field definition?

Understood, but how can I get each formula to pull up their own color. Is it an 'or' calculation. If so, HELP please... Thank you.... Dr.L

I'd like to have a conditional format have the ability for the same field to respond differently to two variables. So, if choice 'A' is selected in the field it would alter the fill color to red while if the condition is 'B' the same field would alter to fill in green...is there a clculation I'd use for this. I can easily format for one condition but multiples is very different... Thanks... Dr.L

Gotcha...thanks! Is there a way to auto size a layout in total, or do I have to adjust each field and graphic indepenedantly? Dr.L Also, perhaps you'll know...when I place a Word document in a container, then try to launch it, something funky happens. JPGs and PDFs open easily and fine, but Word gives me a problem. What's up here?? Dr.L

My solution is for an office environment where users each have different size monitors. So, of course, they each either cannot see the whole database or the database is just too small on their monitor, Isn't there a calculation I can insert somewhere to resolve this issue? I can only see the size adjustment to assorted percentages which aren't always appropriate... Thanks in advance... Dr. L

Much thanks for your patience... I am attempting to enter 4 unique codes into a form. Along with that I'd need descriptions and prices for each which I'd like to generate by simply entering the codes. I'd like to house the codes, description and pricing in one table and just pull the appropriate information into the other. Any other information you'd need? Dr.L

So, if I understand you then my first table to the second table would be: Codes::Code_ID=Code_ID::Code_ID and then from the second table to the third Code_ID::Code_ID=Code_ID::Code_Definition? That should provide me with a one to one relationship? Is that correct?? Dr.L

My tables are DataFile and DX_Codes. I am trying to populate a form with DX codes from the DX_Code table into the DataFile. In order to keep the information separate I've created fields in the DataFile where I need the information from the DX_Codes to come in from. That's why I've used Code_ID = Code_ID... Does that help some? Dr.L

Well I am now getting cross-eyed trying to figure out what I missing... Simply I have a table [table2] with four fields [code_ID, code_Name, Code_description, Code_pricing] where I want to get info for another table [table1]. I can get informationf from table2 by relating the code_ID from the first table. The relationship does bring up the correct relating information. However when I add new fields by duplicating the exisiting fields and changing the names [i.e. code_Name2, code_Name3, etc.] to table1, I can only populate the relating fields to one collection of relating information tghroughout all relating fields. My relation is code_ID = code_ID which seems to be the answer, yet is not. I have attemped to add code_Name to the relationship and even added another table. But... Help please... Much thanks... Dr.L

Just figured that out...I was trying to trim first...THANKS! Dr.L

It seems as though I do have one more question about the date format...once I use: Year (date), how can I trim it to just show the last two digits for the year? Dr.L

Understood...as usual it must have been user error. I believe I may have had it returned as a text rather than as a number...all is well now! Dr.L

Bingo! When now that was easy enough...swear I tried that first, must have missed something as it returned the name of the month. Must have only used it as a text rather than as a number in the calculation... This works also for day and year. THANK YOU! Dr.L

Yup...

I've created a birthdate, Now I need to extract into number form the Month, Day and Year. Certainly there is a simple solution to this... I;ve tried Brian Dunning's as follows with no success so far... Case ( Patient_DateofBirth = "January"; 1; Patient_DateofBirth = "February"; 2; Patient_DateofBirth = "March"; 3; Patient_DateofBirth = "April"; 4; Patient_DateofBirth = "May"; 5; Patient_DateofBirth = "June"; 6; Patient_DateofBirth = "July"; 7; Patient_DateofBirth = "August"; 8; Patient_DateofBirth = "September"; 9; Patient_DateofBirth = "October"; 10; Patient_DateofBirth = "Nov"; 11; Patient_DateofBirth = "November"; 11; Patient_DateofBirth = "december"; 12; // default 0 ) Much thanks all! Dr.L

NO NO! Thank YOU!

Served with FM11 Server