2 Replies Latest reply on Jan 13, 2010 1:10 AM by dingding1028

    How last auto enter last calculated field from a related table?

    dingding1028

      Title

      How last auto enter last calculated field from a related table?

      Post

      I  am a surgeon interested in collecting data for my patients. Especially for their follow up after their operation as this will tell my team where to improve.

       

      To cut a long story short: I am a bit stuck on portal fields.

       

      Using FPA 10 on windows 7

       

      So basically i have two tables one with patient profile and one with their follow up 
      They are linked with a one to many relationship through a portal field in the patient profile "form view "setup.
      Each patient has a unique profile but many follow up clinics where separate variables come in place.
      I have also created a separate "list form" with the fields from the profile table and now i want to include some fields from follow up but not just all fields only the values from their last visit  like for instance the last date they came . How do I do that?
      I know i have to use a calculation but i just dont know which one? and i know i have to use the ID key and some sort function but dont know how.

       

      Much help is appreciated by myself and the patients