How last auto enter last calculated field from a related table?
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 Much help is appreciated by myself and the patients
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