1 Reply Latest reply on Oct 8, 2009 10:41 AM by philmodjunk

    linking tables and autopopulating fields



      linking tables and autopopulating fields


      im a doctor and setting up up a patient datbase for record keeping purposes, i already pay a good sum for billing purposes but i want my own data for my own use, and move from paper to computer based records

      now im a newbie at filemaker and are using FM pro v8;have searched through this forum but cant get things the way i want

      i have set several tables all with their own autogenerating ID numbers

      viz patients-demographics

          hospitals- contact no's and address

          contact assessment episodes- 'where', 'when' and 'condition' at that time

          contact procedures- again 'where when and what'

      patients is parent of other files; linked through relationship graph via ID numbers, patient table has primary key of own ID no, contact tables have their own id's and have patient ID as foreign key

      now i know a basis of database design is not to repeat data among tables

      thus i want to be able to select patient as person who contact was encountered with but with patient id as linking data it it not intuitive to use this as opposed to name

      have got a book about filemaker-> my reading is as follows, portals are for looking at child views from parent view, i want the other way around. thus i managed to set up lookup with pt surname having set this as value field based on Patient table

      ;but over a year will get 1000+ patients, this will mean very long list. also ineed to see surname, forname and dob to ensure i have right client to put in contact table. so i want to be able to filter names so ican drill down to right person, press enter and have their ID put in as foreign key

      read a post here and followed the suggestion, ie i set up layout (for contact episode) and then inserted fields based on parent(patient) table (Viz surname,first name and dob) but cant get it to work, as i said i need some way of filtering right patient

      also have set up relationships allowing patient table to create new records in child table( contacts)

      do i need to some programming to achieve this ?. BTW i was using open office base recently and was able to get list of patients by creating a view of a query

      all help appreciated




        • 1. Re: linking tables and autopopulating fields

          I think you have the following relationship in your database:


          Patients:: PatientID = Contact Assessment Episodes:: PatientID


          Double click this relationship line and select "Allow creation of records via this relationship for Contact Assessment Episodes.


          Now locate or create a Layout that refers to the Patients table.

          Create a portal on this layout that refers to Contact Assessment Episodes and specify the fields you need to document each such episode.


          Now enter browse mode and try it out. You should be able to create new Contact Assessment Episode records simply by entering data in the bottom blank row of your portal.

          To find a specific patient, you can simply enter find mode and enter all or part of a patients name, then click the perform find button.


          Does that do what you need?