Calculating total records (SOLVED)

[clchildress]

I hope this post is in the right place. I have a database with multiple patients. Each patient has multiple records, which is accessed through a portal. Pretty simple so far, but I need to be able to have a field which automatically tells a user how many records each patient has so that they don't have to count. I'm really not quite sure how to do this. The patients are on one table, and the records are on another. Each record has its own serial ID assigned at creation. Each record is related to the patient according to that patient's SSN. What's the best way to handle this?

Edit: I was able to figure this out myself by simply working with functions until I found the right one. I am using the count function, by the recordid field.

Edited February 4, 2008 by Guest