Counting items from another table

[maxn]

Hi All,

Sorry for the noob question, but can someone tell me how to do the following?

I have 2 tables:

Image

-----

Image serial (number)

Image Name (text)

image thumb (container)

Print

----

Image serial(number)

print serial(number)

Print Size(text)

Print is linked to Image via Image Serial.

I would like, from the Image layout, to be able to tally the total number of prints in the print table

for the currently selected image.

I would also like to tally the number of prints with the current selected image

number for various sizes, simultaneously. So for example, I want to know how many 16x20 prints

I have with image serial 5, how many 8x10s etc.

This seems like it should be easy, but I cant figure it out! Thanks in advance,

max

[-Queue-]

Create a calculation in Image of

Count(Print::printSerial)

for your total number of Print records related to the current Image.

If you only want a report that you will preview or print, and do not require it to be viewed in Browse Mode, create a summary field in Print that is a count of printSerial. Then create a report that includes the PrintSize and summary fields in a subsummary by PrintSize and sort the records by PrintSize. Remove the Body in this report, as you will not need it.