Newbie auto enter question

#1

In my database there are 3 numeric fields, A, B and C, where field C = A-B.
Each time a new record is created, I would like FM to set automatically the
value of field B to the value of the previous field A. I'm on Windows XP,
FM8.

Thanks for helping out!

Sharky

#2

Sharky wrote:

Quote:

In my database there are 3 numeric fields, A, B and C, where field C = A-B.
Each time a new record is created, I would like FM to set automatically the
value of field B to the value of the previous field A. I'm on Windows XP,
FM8.

Thanks for helping out!

Sharky

Make field B an auto-enter calculation using the following calc:

GetNthRecord ( a ; Get ( RecordNumber ) - 1 )

Michael Myett

#3

Thanks BigNoel and Michael, I got it running!

"Michael Myett" <michael.myett (AT) adelphia (DOT) net> schreef in bericht
news:NOcgf.12$596.3 (AT) fe09 (DOT) usenetserver.com...

Quote:

Sharky wrote:
In my database there are 3 numeric fields, A, B and C, where field C =
A-B. Each time a new record is created, I would like FM to set
automatically the value of field B to the value of the previous field A.
I'm on Windows XP, FM8.

Thanks for helping out!

Sharky
Make field B an auto-enter calculation using the following calc:

GetNthRecord ( a ; Get ( RecordNumber ) - 1 )

Michael Myett

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Newbie auto enter question

comp.databases.filemaker comp.databases.filemaker

Newbie auto enter question - 11-20-2005 , 03:22 PM

Re: Newbie auto enter question - 11-20-2005 , 11:20 PM

Re: Newbie auto enter question - 11-22-2005 , 02:02 PM