Mac OSX 10.4 with fm 8.1

I am producing a lot of tv short segments regrouped in three modules
with differnet names (health, futur, environment). I'd like to give them
an ID composed of the accounting number of the show (6300) the first
letter of the module (H for Health, F for...) and a number indicating
its place in the module (1 to 4). All fields are already parts of my
template. What is the script to create the complete id (6300F1 for
example). Thanks for your help

Chris

What about an 'ID' field calculated as :
ID (calc) = Show# & Left(Module; 1) & n
n being the place in the module ?
But I would advise to add another 'Record#' field (number) unique per record
with option set as autoenter serial. It would be incremented automatically
when creating a record. This would make sure each record has a unique and
reliable record number.
Remi-Noel

"Christophe Planchais" <chriplan (AT) free (DOT) fr> a écrit dans le message de news:
chriplan-596B70.05192712122006 (AT) ...OT) proxad.net...

Look at the text functions in Help:

Show & Left ( Module ; 1 ) & Place

Matt

On 12/11/2006 23:19:27 Christophe Planchais <chriplan (AT) free (DOT) fr> wrote: