home *** CD-ROM | disk | FTP | other *** search
- Newsgroups: comp.sys.mac.databases
- Path: sparky!uunet!wupost!gumby!destroyer!ubc-cs!unixg.ubc.ca!kakwa.ucs.ualberta.ca!access.usask.ca!ccu.umanitoba.ca!djwiebe
- From: djwiebe@ccu.umanitoba.ca (Darren J. Wiebe)
- Subject: Re: Another FileMaker Pro question
- Message-ID: <1992Aug16.221538.5080@ccu.umanitoba.ca>
- Organization: University of Manitoba, Winnipeg, Canada
- References: <1992Aug14.090939.14131@nntp.uoregon.edu> <1992Aug15.213459.13281@dartvax.dartmouth.edu>
- Date: Sun, 16 Aug 1992 22:15:38 GMT
- Lines: 55
-
- In <1992Aug15.213459.13281@dartvax.dartmouth.edu> geoffb@coos.dartmouth.edu (Geoff Bronner) writes:
-
- >In <1992Aug14.090939.14131@nntp.uoregon.edu> srussell@cie.uoregon.edu (Steven Russell) writes:
-
- >>Ok, here's another question: I want to be able to create a field
- >>that adds values from two other fields. If field "A" contains the
- >>value 20, and field "B" contains 17, I want my proposed field to
- >>become 37. So far, this is trivial, but I would like this same field
- >>to be selectable for manual data entry if both fields "A" and "B" are
- >>undefined. If this is not possible, I will settle for having the
- >>field be selectable for data entry without depending on the values in
- >>fields "A" and "B". Is this possible, or am I asking too much? I've
- >>looked through the manual for help with this, but haven't found a way
- >>to make it work.
-
- >The only way you could do this would be to define your proposed field as a
- >calculation field, let the calculation run, and thenb redefine it as a
- >number field. But you would have to re-run the calculation on an irregular
- >basis.
- >geoffb@Dartmouth.EDU - Computing Support Consultant, Tuck School of Business
-
- Huh???
-
- Truthfully, the only way to accomplish this is as follows:
-
- Field A & B are numbers
- Field W = A + B (Calculation)
- Field X = Number field with auto-increment serial number (Start at say 1)
- Field Y = Number field with defined values of 0 and 50000 (arbitrary but large)
- dfg
- :wq
- Field Z = X + Y
-
-
- Field C = Number field which looks up within the same file and copies the
- contents of W into C when a new value in Z matches a value in X
-
- In this case if you define Y as radio buttons and size the box so you can't
- see the 0 and 50000, you have a little toggle switch to perform the lookup, so
- you can type in field C, but whenever you toggle, the value will be replaced
- with the actual calculation...
-
- There are a couple ways to make it work a bit easier, but they are more complica
- ted in the formula's and require a special procedure when entering data, this is
- the most user friendly way...
-
- (<=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=>)
- Darren J. Wiebe | Internet: djwiebe@ccu.umanitoba.ca
- Box 141, Station L | AppleLink: CDA0010T
- Winnipeg, Manitoba, Canada R3H 0Z4 | Quote: 'scuse me,
- Disclaimer: Disclaimer! I don't need | while I puke and die!
- no stinkin' disclaimer! | -The Dead Milkmen
- (<=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=>)
-
-
-