one table one layout two portals?

[Mark Reed]

Im looking to accomplish the following:

I have one table - a transactions table that has two types of records: expenses and income in it. They are defined with a TransType field.

I would like to have a screen that does something like this:

top area--------------------------

transaction entry area

----------------------------------

list of income list of expenses

the top portion would have an entry interface

below that would be two portals - one on the left showing income one on the right showing expenses.

I can get one portal working fine - but I cannot figure out how to make a portal only show category income. If I can do that I can make a second one and show only cat expenses.

How can I specify a filter for the portal? I see many sort options, but nothing to say "only return the records to this portal that meet XYZ criteria"

Thanks in advance for any guidance you can provide.

[mfrapp]

just create 2 calculation field (indexed)

Transac::expense_const = "Expense"

Transac::income_const = "Income"

and then create 2 occurences of your table for expenses and incomes and create a relation from your main table with the calculations to the occurences in TransType field.

t.zip