Counting field values
I have tried and tried to figure this out, and decided to ask for help (instead of continuing to bang my head against the wall!).
I have a simple database with 2 main tables- patient data and cell information. One of the fields in my table of cell information describes the plate which the cell was on. I need to count the number of plates processed for each patient to display on the patient summary layout. Every iteration I've tried either gives me a large number (for example, if I have 100 cell records, it returns 100 when I try to count the plate field, because it counts every instance as one), or it gives me 0. I have looked at the other forum posts on this topic and can't seem to make it work. The plates are simply numbered p1, p2, etc. Can anyone help?
I am using FMP 11- thanks in advance!