calculations Help !

[famous]

Help..I have tried but failed.

I have a database for a videotape library using Version 5.0 on PC

As well as client,title, duration etc it has two key fields.

"Master Number" and "Reel Number"

These fields are defined as numbers.

There maybe an entry in "master" but not "reel", vice versa or no entry in either.

When I add a new record to the database, I want to find the highest value in each field, add 1 and create a new record placing the calculated values in the appropriate fields.

I cannot figure out how to store and retain the value of each find.

Can anyone help.

Regards,

David Barrett

Melbourne, Australia.

[LiveOak]

Define a field:

Constant (calculation, number, indexed) = 1

Create a self relationship (call it "SelfRel") with Contant <--> Constant

Create a new record script:

New Record/Request/Page

Set Field(Master Number, Max(SelfRel::Master Number) + 1)

Set Field(Reel Number, Max(SelfRel::Reel Number) + 1)

-bd