View Single Post
  #1  
Old July 8th, 2005, 02:20 PM
Greg McLandsborough
external usenet poster
 
Posts: n/a
Default RECORD based on other Records

Is it possible to enter a record value with is a function of other record. I
want to be able automatically enter a concatinated string into a record,
base on the value of two or more record value.

I have a [project number] which I want to contain the first two digits of
[client id]&"-"&[directory]&"-"&(Autonumber).

Is this posible? Should I do this in the table of form. I could also
probably leave it blank, and any program that requires it could create it!

Any help appreciated.