i have three columns
hrs_due, hrstaken, and totalhrsneeded
i need the default value of hrs_due to = totalhrsneeded - hrstaken
the data type of all is number>long integer, and i try to key =[totalhrsneeded]-[hrstaken] into the default value of hrs_due but it
will not accept it can anyone plz help??
thanks

You can't do this at the table design level. At the form design level
however, you can catch the On Insert event.


<jjrmy1 (AT) earthlink (DOT) net> wrote