Ok, lets see if someone can help me.

I have 2 tables. Table1 has 26 records and 3 fields. ID field contains just a letter, a-z. The other two fields contain data about the character.

My second table "Table2" is the user input table. They select a-z from a dropdown based on the ID Field in Table1, then Input other Table 2 specific information.

Here is what I'm trying to do.

When I view Table1, and sift through the 26 records, of a-z. I want to see how many times each record is used in Table2.

So I go to record "a" in Table1, and there is a field "Used_Count" that lists exactly how many records in Table 2 have used "a" from the dropdown Menu. Or how many records are related to record "a".

I want this to be a calculation field in Table1. Can anyone help me? This might or might not be a custom function but any help is greatly appreciated.

Create a relationship from Table1::ID to Table2::fkID (where fkID is the letter field) and make Used_Count equal Count(Table2::serial) or Count(Table2::fkID).

Thanks man, thanks for making me feel stupid. So easy, guess I was just in one of those places today.

Thanks a lot.