3 Replies Latest reply on May 3, 2010 11:57 AM by philmodjunk

    Filemaker Pro 11 Medical database Letme



      Filemaker Pro 11 Medical database Letme


      Hi guys, i am using FMP 11 for mac and i am a total noob at it =(

      I am a college teacher (med school) and i need to complete a database until the end of this week.

      The problem is that i can't seem to figure out how to code some of the functions. I tried reading everything i found but i still couldn't do it . So i beg for your help plz :(

      Le te explain what i am doing. I grabbed one of the templates from FM "Family Medical Records" and i am trying to mod it =(. The aim of the database is the following. Our students are divided by years and in those years by groups of 2 students. Each group works together when seeing patients and each patient is connected to one of the students but the other one helps. The groups consult several patients. The objective of the database is to follow those patients appointments, register the followup consults (so that the students don't forget to follow the patients), see when the next appointment is and know which student is consulting which patient etc etc etc...

      I will put a SS of the few i have done.... here it is:




      Let me explain it... The field "Ano de Curso" is the students grade. "Ano lectivo" is the school year. "Groupo" is Group and "nome do aluno" is the name of the student.

      It should be like this: I would select for example year 10/11, then 5th grade... then Group 1 and then when i click "name of the student", the 2 names of students that are in the group 1 of that year and grade would appear in the dropdown list so that i could select one.

      After selecting the student, the teacher would be able to fill the "Paciente/Patient" field with the name of the patient that the student is consulting and the date.

      After that, it would be possible to click the patient name and go to a subpage where there would be a summary of all the appointments the patient had and all the treatments made etc etc etc...


      Do you think this would be possible? I know i am a noob =( i am sory for that =( this is something i really have to do until the 5th May =(

      I beg you guys for some help...

      I am sure my explanation was somehow confusing and without the correct FM language... if any of you could add me to a online chat so that i could explain everything and get some help, i would be eternally grateful.

      Thank you a lot for your time and help.


      Rui Isidro 

        • 1. Re: Filemaker Pro 11 Medical database Letme

          Oh, another thing i forgot and i can't seem to successfully accomplish.

          In the "Patient" fields, i would be able to fill the several fields with patient names and click them as i explained. But, it would be nice if i could search for a patient name in all the fields... the page would present a list of all the patients and date of next consult they have... but i would also be able to search for a patient name independently of witch field it is in.

          The problem i have is that i have independent fields and i can only search patients that are in, for example, the 4th line if i write the name in that same line when i use search...


          Once again i am sorry for the lack of correct terms =(

          Srry guys...

          And thank you very much...

          • 3. Re: Filemaker Pro 11 Medical database Letme

            A number of us do not access the forum over the week end...


            I think you need to learn more about how to set up different tables of related information and how to use portals to work with such related information.


            I sounds like you are defining a large set of fields in a single table for patient information that should be entered in a related table that you can link to your Medical Student's records.