Breakdown by Date

[Steve G]

I have a table ("registrations") that has a number of fields, including a DATE field that's automatically populated with the creation date. When a new registration happens the current date is automatically populated there.

I also have another table ("shows") that has a relationship to the "registrations" table based on the show ID number. As it is now, there are 55 registrations 'visible' from the "shows" table.

What I need is, on the "shows" table, a list/breakdown of registrations by date. For example, let's say that there were 10 registrations per day for the past five days, plus five registrations today. What I need is a portal on the "shows" page that contains this information:

2/6/2009 10

2/7/2009 20

2/8/2009 30

2/9/2009 40

2/10/2009 50

2/11/2009 55

Like many things FileMaker this seems like it should be easy but I've been banging my head on it for a couple of days now and I'm no closer than I was before.

How exactly can I get this done? Thanks.

[mr_vodka]

Cant you just use a report for this?

[Steve G]

Probably, but the people using the database don't want it that way.

[mr_vodka]

Well I would still suggest a report for this but if you must have it in a portal, you may want to do a search for Ugo's method on these forums.