Help! I'm wondering how I can change the docket # automatically using the first 3 letters of the Company Name and then some numbers after it.

For ex: Company Name = Nortel

Docket ID = NOR100

This should change as company name changes.

Thanks.

Why not try having three fields:

Company Name (TEXT FIELD)

ID # (TEXT FIELD)

Docket ID (CALCULATION FIELD)

The calculation for Docket ID would be

Left ( Company name, 3) & ID #

When you change the company name then the first three letters will change.

If you change the ID # then the number after the three letters will change.

Hope this helps.

Thanks!