5 Replies Latest reply on Jun 20, 2012 12:34 PM by hyunyu

    Need help how to show "last delivery date"



      Need help how to show "last delivery date"


      Hello, I have just started using FileMaker Pro, and I am trying to set up layouts and fields, and having some troubles:

      I am in a pharmacy and we deliver maintenance medications in monthly basis.  I have a table for "medications" that shows what medications a patient is on, etc.  I also have a seperate table for "delivery dates" which shows when the medications were delivered.  I want to show when was the last time a medication was delivered to a patient, based on the data from "delivery dates" table.

      I thought protal was the best approach, and i used filter for IfValid for every entry in "delivery dates" field, so that when the field is empty, it wouldn't show that filter; however, this portal is still showing all 18 fields that i created prior w/ nothing on it.

      Can someone please help me how I can resolve this?