Hi,

I have a simple database where two tables of data are connected by the
field Record_ID. When I display records from the main table, I have a
portal which shows the records related through Record_ID. The records
in the portal are characterised by the field Interval_ID. The number
of records in the portals is not fixed fro Record to Record. For
example ..

Record_1
Interval_1
Interval_2
Interval_3
Record_2
Interval_1
Interval_2
Record_3
Interval_1
Interval_2
Interval_3
Interval_4


I then perform aggregate functions such as SUM on the Records.

What I would like to be able to do is show the above, but with certain
of the Interval records omitted (and retain the aggregate
calculations, but on the reduced set of Intervals). For example ..

Record_1
Interval_1
Interval_2
Record_2
Interval_1
Interval_2
Record_3
Interval_1
Interval_2

Is this possible?

Note that if I do an (Omit) Find and put >2 in the portal for the
Interval_ID field, what I get back is

Record_2
Interval_1
Interval_2

Which is not the desired result.

Thanks in advance,

Nimrod.

Nimrod wrote:

The portal always shows the child records. I'd put a buttom on the
portal line that changes a field in the child record, so that the key
does no longer match. The child becomes an orphan and disappears from
the portal.
--
http://clk.ch

In article <1hxav4k.1l3a1qi87yykgN%clk (AT) freesurf (DOT) ch>,
clk (AT) freesurf (DOT) ch (Christoph Kaufmann) wrote:

You could define another relationship between the tables, that will
restrict the relationship to the extra criteria you specify. Then a
portal based on that second relationship will show only that more
limited set of records.

--
For email, change <fake> to <earthlink>
Bill Collins