Hello all,

I have been asked to make some modifications to an existing system. I have run into a problem with one of the requested changes. I hope I can explain what I am attempting to do.

I have a form that is to be used in browse mode being viewed as a list. I have the header set up with the column headings, etc. I have a field that is set up as a drop down box for the size - small, medium, large. Those are the only choices.

What I would like to do is place 3 fields into the header section that will keep track of the number of each size that has been selected. I would like the totals to update when the sizes are changed/selected.

Do any of the gurus out there have any tips or places to look?

Thanks in advance!

One method - probably you will see many others before too long.

Make a global text field in your table: Small with value "small". Make a second occurrence of the table in question, SMALL say, and then relate the size field in SMALL to the global Small and define SmallCount as an unstored calculation Count(SMALL::size). Copy that for medium and large.

See the demo I have posted here - it seems like the same type of problem.