Jump to content
Sign in to follow this  

Last Patient Record

Recommended Posts


I am using 6, but in the process of upgrading to 7 so If it is not possible in 6, then let me know about 7.

I would like to be able to have a patient's last vitals show up. May sound simple, but I have tried a lot of things.

Lets say that I have person a, b, and c. They are stored in "Main" database. Their vital signs are stored in vital signs database. The two are related by serial number. The vitals are shown through a portal and for a new visit, they just enter the vitals at the bottom of a portal. In a Visit database, which is related by serial number also from main, I would like to be able to look at say date 5/25/2004 and have the last vital signs appear, I would like from them to be calculation fields so that if a new date is entered between two old dates, the data will automatical update it's self.

So I guess what I need is a relationship to it's self based upon the serial and the date of the current record. How do you make it so that it shows the values that are less that that records date only?

Share this post

Link to post
Share on other sites

In version 7 you would create a non-equijoin relationship based on date.

Share this post

Link to post
Share on other sites

Thanks transpower, but does anyone know if it is possible in version 6. I am not using 7 yet and I need this before we upgrade (that is if it is possible)

Share this post

Link to post
Share on other sites

In your VitalSigns db, create an unstored number calculation of visitdate = Visits::visitdate. Then modify (or add) a relationship from Visit to VitalSigns to sort by the calculation ascending and visitdate descending. Then make your last vital signs calculations of relationship::field. This should work because the sort order of a relationship determines what the first related record is. I haven't tested it, so let me know if you can't get it to work correctly.

Share this post

Link to post
Share on other sites

To see multiple dates in a portal, a now-obsolete 6 method is the "multi-line" key technique, which is to build an Unstored calculation that produces the date, and a bunch of dates before it. The calculation looks like:


Date - 1

Date - 2


The dates are converted to numbers, which is FileMaker's internal method. So you create a calculation with result number for your date also.

The multi-line above is related to the "date as number" field. So the date, or any earlier (within the range)* will give a match. I used a global field for the date to set the start of the range. But you'd probably use a regular date field. Just change the date field in mine, and its name. Then you can copy/paste the calculation.

*The range can be fairly large, up to 64,000 (30,000?) characters. I did 730 days, 2 years, and it's only 5116 characters. The FileMaker layout was not long enough to show them all ???-)

The "Smart Ranges" technique would give you an infinite range I think; but requires some serious learning. Depends on your range.

In any case, it should be an Unstored field, so it doesn't bloat the file; but it is not instantaneous.

Included is a calculation to help MAKE the calculation; as well as a script to produce the numbers needed. You may need help with that.


Share this post

Link to post
Share on other sites

Wow Fenton, that was a lot of work. I had to add a Serial field, change the datevisitnum to Serial & NumtoText(DateVisit), change the _cdate_txt to include the serial number, created a script to copy all records ( could not find how to do it manually), it works. thanks. I wish the people I work for would upgrade to 7 sooner, I am doing a lot of useless stuff, but I get paid. ???-)

Share this post

Link to post
Share on other sites

Good you could get it working. Hold Alt (Option) when Copying to Copy All Records. Rarely needed.

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Similar Content

    • By Tony Morosco
      I'm a botanist, and the tables I am working with are for tracking botanical garden collections. The data represents plants in the garden, and the plants are tagged and show up in the database.  The tables I am working with were created in FMP 7, and I'd like to open them up in FMP 11 (or later.)  The system hasn't been used in years, but still has valuable information.
      One of the tables is giving me problems using the FMP convert and recover commands.
      These tables are all inter-related.  The main table is the Accessions table, which contains records for all of one kind of plant, from the same source, received on the same date.  It is basically a museum standard.
      The other tables are related to each other through this one main table.  The Species table is related to the locations table through the Accessions table. 
      (i.e.  table A relates to table C through the table B, the intermediary)  
      From the Locations table, we can't see the the species information unless the accessions table is present.
      When issuing the open command on the main table to convert the database to FMP 11, I get the message:
      "Accessions.fmp7" is damaged and cannot be opened.  Use the Recover command to recover this file. When using the Recover command from v. 11, I get another message:
      WARNING: problems were detected while recovering the database.  Please review the Recover.log file to see where problems were found and their severity.  The recovered file should NOT be used going forward; copy only the most recent work from it into a backup copy of the original file. Recovery results:   File blocks: scanned and rebuilt 563 blocks, dropped 214 invalid data blocks.   Schema: scanned fields and tables, 1 items modified   Structure: scanned; 1 items modified   Field indexes: rebuilt  
      Opening the recovered database, there are only three records present.  There should be hundreds.  So obviously I am looking on how to wrangle this database open.
      I've attached the log file here, as well as the database structure map.  
      The other files have converted just fine.  But since the main table won't open, we are kind of stuck.
      I can share the files with you through Dropbox or whatever, if needed.
      Please let me know any thoughts you have, either basic or advanced.  And ask for any clarifications or additional questions.   :-)  

    • By Tumma K
      Hello, All!

      I am an aspiring developer for Filemaker. The company I work with is stuck in the past working off of Filemaker Pro 4.1

      I was given the task of bringing us up to Filemaker Pro/Server 13. So far my conversion prototypes are successful but we recently had a layout issue that can only be fixed in versions 3-6 (as the file is an .fp3) I work off of a macbook while our network is all Windows 7. In order for me to repair the layouts without tampering our active database, I decided the best option is to repair a copy of our solutions off the network. Unfortunately, when I go to download the trial version of Filemaker Pro 6 off of the respected website, the file is corrupt! I've tried multiple times, with different extraction apps and in different directories.

      My question is;

      Does anyone know a place where I could obtain version 6 (or better yet, 4.0) for an OSX computer? I've looked everywhere!
      Thank you for your time,
      Tumma K.
    • By MrEddByrnes
      I'm hoping my question can have a happy ending. In the mid-90's, I purchased Filemaker 3. When Filemaker 5.5 Pro was released, I bought the update CD, which requires the user to either have FM 3 installed or to have the installation CD for FM 3. I've used it all these years, most recently with Windows XP Pro, and it has worked just fine. The databases I began with were long ago converted to FM Pro 5.5 databases.
      I'm still using FM Pro 5.5 on a laptop with WinXP Pro, but in 2013, I purchased a PC with Windows 8. I haven't been able to install FM 3 on it, therefore can't install FM Pro 5.5. I am retired and rarely use Filemaker, but I have a few Filemaker databases I'd like to add to my Win 8 machine. I don't feel it's worth upgrading FM for the sake of using a couple of databases.
      Has anyone else run into this situation and/or have a (possible) solution? Is there perhaps any other software that can read FM 5.5 databases? Thanks in advance for your help.
    • By bmill
      I am using a custom filemaker solution for medical office billing written with fp5 running on a mac with snow leopard. In addition, I have a patient management db (which I wrote) that is linked through pt. ID number to the billing program allowing transfer of some demographic information (name, DOB, etc).
      Other than being limited by hardware restrictions, the billing program serves our needs for now and upgrading to fp12 will take some time (and money).  In the meantime, I am upgrading my pt. management program to fp13 and would like to move new patient demographic information from the billing program ( fp5 running on snow leopard through Parallels) and the new pt management program ( fp13 running on OS X 10.9) on the same mac.   
      Ideally, demographic information would be entered once into fp5 and then a scipt would make the data available for fp13.
      Any ideas on how to make this work?
    • By randyinla
      Hi, can anyone tell me why my on-line database might have stopped allowing me to delete records?  All of my access privileges and passwords are correct.
  • Who Viewed the Topic

    14 members have viewed this topic:
    arni  xlbycharles  Agentshevy  MikeKD  Peter Jambors  Aussie John  rwoods  BruceR  doughemi  Steve Martino  Lee Smith  Fitch  No_access  spand 

Important Information

By using this site, you agree to our Terms of Use.