Calculation to show Database Name

[Steve Faulkner]

How can I create a calculation field with the same name as the database. Only showing the name of the database, not all the databases that are open.

Many Thanks

Steve

[QuinTech]

Hi Steve, you want the name of the field to be the same as the database name, or the contents?

If it's the latter, Get ( FileName ) will work nicely.

Jerry

[Steve Faulkner]

Thanks Jerry

Do you know why the name is not re-calculated when the file is saved as a different name?

I thought the fact it is a calculation would have overcome this.

Thanks

Steve

[Chuck]

Change the field calculation to be unstored (found in storage options in the calculation definition).

Chuck

[Steve Faulkner]

Thanks Chuck

You hit the nail on the head

Cheers

Steve