kenseye

I have a medication table listing medications and a date that each medication is discontinued. I would like to list the medications in a field if it does not have a discontinued date. Otherwise stated, I would like to list only active meds while not including discontiued meds. Using List (Medications:medication) gives me all meds. What function do I use to incorporate a qualifier prior to listing?

thanks

I have a test field and want isolate only the first characters before the -. ex: 120-1 to 120 or 30-3 to 30 this should be simple but for the life of me, I can't figure out which function to use.

What seems simplest is to use Goto Layout( Get(ScriptParameter)&"_Form") and pass the object name as text as the script parameter eg "Insurance" for Insurance_Form or "Medical" for Medical_Form. I tried this earlier but it didn't work. Now it seems to. I must have screwed up the first time. thanks

I'm trying to write one script that will direct the user to the correct layout based on which tab is clicked, its object name and combining to form the layout name by calculation. ex: clicking the Medical tab runs the script with Goto Layout( objectname&"_Form"). I tried get(activelayoutobjectname) without success. Button is named: Medical, Layout is named: Medical_Form. I'm just trying to be efficient and write one script that will work with all tabs(buttons) to navigate to the proper layout.

Creating separate global fields that allow me to create portals exhibiting select information looks like the way to go. thanks

I have two layouts, one with all types of visits shown ( linked by Patient ID) and another layout displaying only a) Cataract post-ops and LASIK post-ops. If I use the layout with all exams and amend the relationship to include the global examtype, then selecting the exam type in the global field with check boxes or radio buttons work OK. If I use the second layout and create a new relationship based on Patient ID AND globalexamtype to isolate cataract and lasik post-ops, the relationship fails listing only a single exam occurrence multiple times. I'd like to have two relationships, one based on Patient ID and the other to isolate types of visits because they are displayed on different layouts. I can't create that second relationship.

If I use the original relationship and add the exam type link, it works, but a second relationship goes haywire.

I have one layout with exams linked to patients by Patient ID#. I created another relationship between Patients and Exams by ID# AND g_examtype with Exam type as in your example. The second relationship did not work. I removed the AND global field link (only ID# link remaining) and it does not work. This pulls multiple entries of the last exam. Can there be 2 relationships that have with the same ID link?

If I do set the globtype to cataract post-op for example, I would then need to set that field to cataract post-op each time I go to view the cataract portal, then set it to LASIK post-op when viewing the LASIK portal. Correct? It doesn't work as well on tab displays as it requires a double click to view the proper data, but I'll keep working with it. thanks for the recommendation.

I'm displaying an Examinations portal in a patient record and want to display only post-op examinations and not all examinations for that patient. Is this possible... ie showing only a select group of records from all of the patient's exam records within the portal?

If in a layout I have fields that have drop down value lists or calendars, how do I get them to display automatically when I script goto[field] and pause the script for a selection or response?

Would I then need to add a Commit Record step when closing the file or record?

I ended up redoing my file references and that sped things up. Redoing file references can create all sorts of broken links and I'm fixing them as I go. thanks

I know somebody must have experienced this already... When entering a new record from the file represented by the portal, the record is not visible in the portal until I go to another layout and come back. What am I not doing at the close of the file? This db was first written in FM5, converted to 8 and uses separate files not tables.