Re: FIND across multiple tables in FM 7.03

David Robins, MD <trashadd@xxxxxxxxxxx> wrote:

> Actually, I'm not an sql-guy, (but not really a newbie - been using FM since
> version 1.0.
>
> That said, what I have is a table for Exams, and a table for Surgery. They
> are related by the medical record number (I'm using it as an electronic
> medical record.)
>
> I was trying to do a manual FIND (not in a script) of patients in a certain
> age range, with a certain eyeglass power (both in the Exam table, and combie
> it with a Surgery data field, in the other table. And yes, once you switch
> wndows, the FIND goes away.
>
> So for some occasional queries, then, it looks like I would have to pull the
> Surgery fields over to the Exam layout as related fields? (in FM 7.03)

You could try a portal from one of your tables - search the portal
first; then constrain your found set.


If you want to preserve a found set that you arrived at after complext
queries (my main database can string up seven or eight
find/constrain/expand requests) I've found the quickest way is once
you've got the dataset you want, simply mark a field as
'belongs_to_current_query'. (replace field) If you then go off and do
another complex query on a different segment of your dataset, you can
access it fairly quickly.

Catja


.

Relevant Pages

  • Pre-screening for the CMT exam
    ... EXAM CONTENT OUTLINE ... Terminology and spelling related to anatomy/physiology, clinical medicine, ... alternative medicine, cardiac surgery, ... Which of the following drugs is a cardiac medication? ...
    (sci.med.transcription)
  • Re: Surgery Update
    ... >has been a success so far. ... >the four major sinus cavities, but they also did an interesting ... I had nasal surgery once to clear my nose (anyone who has seen my face ... exam though, on the basis of the written stuff). ...
    (rec.music.makers.guitar.acoustic)
  • Re: "good luck for"
    ... an exam, an athletics competition, surgery, etc. ...
    (alt.usage.english)
Loading