AnsweredAssumed Answered

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

Question asked by dingding1028 on Jan 12, 2010
Latest reply on Jan 13, 2010 by 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

Outcomes