Newbie auto enter question

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


.

Relevant Pages

  • Re: Newbie auto enter question
    ... > Sharky wrote: ... >> In my database there are 3 numeric fields, A, B and C, where field C = ... >> A-B. ...
    (comp.databases.filemaker)
  • Re: Automated Form Validation?
    ... > before putting it into the database - even down to things like making sure ... > that numeric fields contain numeric data, ... What guarantee can you give that best practice ... then the validation rules aren't going to change. ...
    (comp.lang.php)
  • Re: How set default value
    ... Select this check box to have the program convert null values from the database to a 0 (for numeric fields) or a blank. ... To do this you could use a function such as COALSCE in SQL Server to control what is returned from the database. ... In the Default Settings Option dialog box and under the Reporting tab, ...
    (microsoft.public.vb.crystal)
  • Re: update 500000 records with adodb.recordset resize the mdb from 140M to 2G
    ... the size of the database. ... The upper limit of a JET database is ... > text and numeric fields are updated. ...
    (microsoft.public.data.ado)
  • Re: help with mySQL and ORDER BY
    ... "Jochen Daum" wrote in message ... >>numeric fields.) ... > I understand what you want, but a database doesn't suppport that. ...
    (comp.lang.php)