getnthrecord ?

[drrehak]

hi newbie here.

I am creating a solution for my optometry practice. I have a layout which has all the visit data. Prescription, vision, ect. I would like to have a Last visit field which auto-enters the last visit. should I use the getnthrecord function? or is there another way to display this?

-Kevin

[John Mark Osborne]

Do you have your visits stored as one record per visit in a Visits table related to the Patients table? If this is your design, GetNthRecord isn't the best choice since it looks at the found set of records. What you want to do is look at the records related to a Patient record and pick the latest one. You could use the Last or Max function in an auto-enter calculation or a regular calculation depending on what you want.

[drrehak]

yes, visits table related to patient table. Each record is a visit.

How would last or max work? once i create a new visit for a given patient, i'm actually looking for the second from last record. How do I look for only records which match the px_id? Aren't we really getting back to establishing a foundset, and looking at a specific field within the foundset?

-kevin

Edited November 3, 2006 by Guest