3 Replies Latest reply on Feb 1, 2009 2:01 AM by raybaudi

    dividing related records into two portals

    DonorTracker

      Title

      dividing related records into two portals

      Post

      Noobie question from a Bento graduate:

       

      I have an INCOME Table that lists individual income items. If these are paid with a check, the check_number field is filled in.  If by cash, that field is empty. There is a deposit date field, too.

       

      I have a DEPOSITS Table that is linked via the date field to the INCOME Table.

       

      I want two portals in the DEPOSITS Table.  One with checks and one with cash.  Currently I know how to set up a Portal that holds all the income for a particular deposit date; but how would I split this into two Portals, where one holds related records which have check numbers, and the other portal holds the related records that don't have check numbers?  Thank you!