Hello everyone. I am working on my first filemaker database using some of the more advanced functions. I have had good luck finding answers via google so far, but I can't find anything for this because the search terms are so generic!

Sorry for the noob question, any info or links are appreciated.

I am setting up an employee classifieds database. One of the restrictions is they are limited to 5 ads per month. I would like to calculate the number of times the emp_number from the current record appears in the rest of the database. A simple task but I just don't know where to start.

Thanks!

You will have to provide more detailed information about your structure ( tables, relationships, etc) for us to help you more precisely.

However, if you have a relationship where you are looking at a Employee record and you have a related Ads table keyed on emp_number, you can use a Count ( Ads::pkAdsID)

Oh and P.S.

Welcome to the forums. :

I think another table is the way to go. It also solves my problem of trying to search omitted records. Let me give it a try...

Thanks!