Path: utzoo!news-server.csri.toronto.edu!rutgers!apple!mrspoc!itkin
From: itkin@mrspoc.Transact.COM (Steven M. List)
Newsgroups: comp.databases
Subject: Re: Paradox 3.5..Fields->Records?
Message-ID: <1991Mar8.214222.13808@mrspoc.Transact.COM>
Date: 8 Mar 91 21:42:22 GMT
References: <1991Mar7.161215.25643@rodan.acs.syr.edu>
Reply-To: steven@Transact.COM
Distribution: usa
Organization: Transact Software
Lines: 35

mjducey@rodan.acs.syr.edu (Matthew J. Ducey) writes:

>I Just got Paradox and I'm trying to build a DB that will show a bunch of
>accounts. I also need to show payments received(one check a week). I don't
>want to see some 52 checks on the screen when I review an account. Can I
>have the check field point to another \record of checks to include the 
>date, number, and amount? Is this possible?  Can I please have an answer
>written in 'new user lanuage'?

Since I'm hardly an expert, my answer is based on limited experience but
is therefore likely to be in 'new user language'.

My suggestion would be to define a new form that incorporates the master
account table as the master table, then includes a multirecord subform
on that table to display the payments.  The master form would permit you
to page through accounts, while the subform would show only as many
payments as there are rows on that form.  You could then page through
the payments using first F4 (down image) and then the PageDown key to
step through the payment records.

Check out Chapter 7 of the User's Guide under Modify, where it talks about
doing data entry in MultiTable forms.  There are other places, too, but
this one discusses how to USE the forms.  I think the definition is covered
in Chapter 2 of Presenting Paradox Data (at least that's what Chapter 9 of
the User's Guide says! %^}).  And I think it was also covered, perhaps 
briefly, in the Tutorial.

Good luck, Matthew!

Steven
-- 
 +----------------------------------------------------------------------------+
 :                Steven List @ Transact Software, Inc. :^>~                  :
 :           Chairman, Unify User Group of Northern California                :
 :                         itkin@Transact.COM                                 :