home *** CD-ROM | disk | FTP | other *** search
- Path: sparky!uunet!ogicse!decwrl!csus.edu!netcom.com!netcomsv!cruzio!rhaven
- From: rhaven@cruzio.santa-cruz.ca.us
- Newsgroups: comp.databases
- Subject: Re: Paradox Help again!
- Summary: Paradox calculated fields on forms
- Message-ID: <4598@cruzio.santa-cruz.ca.us>
- Date: 5 Nov 92 07:33:30 GMT
- Article-I.D.: cruzio.4598
- References: <s897336.720843298@minyos.xx.rmit.OZ.AU>
- Sender: rhaven@cruzio.santa-cruz.ca.us
- Reply-To: rhaven@cruzio.santa-cruz.ca.us
- Lines: 26
-
- In article <s897336.720843298@minyos.xx.rmit.OZ.AU>, s897336@minyos.xx.rmit.oz.au (Lip Meng Soh) writes:
- > Hi netter,
- > I was wondering if Paradox can perform "calculation" on the data-entry field?
- > That is if the user fills in the fields ( ie. qty and price per unit), can the
- > field- amount (ie. qty * price per unit) be auto-generated ?
- >
- > ***********
- > Lip Meng, SOH
- > Email: s897336@rubicon.bf.rmit.oz.au
- > ***********
-
-
- Yes, Paradox forms can automatically generate calculated fields based on
- other fields (or other, outside information as well). The new 4.0
- programming techniques make is easier to do selecting recalculations
- as well (like total value in a field for all the detail records for this
- master record). This requires PAL programming, but most PAL programming
- is taking the normal Paradox behavior and changing selected bits of it
- to do exactly what you want. You end up programming the exceptions
- and leaving the rest to Paradox.
-
- One note: these calculated fields on forms are display-only. If you want
- to have a real data entry field set to a default value based on other
- field values, you would use the PAL programming method.
-
- Cheers
-