serial client_id needs import ability

[vierdewereld]

Untill now I've been very happy with my auto increment Client_ID.

It increments by 1, from the last highest recordnumber.

The fields I use are:

Client_ID

Right("0000" & GetAsNumber(serial); Max(Length(GetAsNumber(serial)); 4))

serial

If(Get(TellingTotaalaantalRecords) = "1"; "1"; NextClientSerial)

the If is needed when the first record is being created.

NextClientSerial

Max(Global::c_ClientID) + 1

The Global is the common 1:1 relationship

This is exactly what I want. Except I just can't seem to get it to work with importing other records.

I thought it worked but it doesn't (anymore).

I've tried a couple things but I think that the relationship Global: doesn't work while importing.

Any suggestions are very welcome...

[vierdewereld]

A solution I'm using now is with the script step replace on the serial field after the import:

SerialIncrement ( Max(Global::c_ClientID) ; 1)

But perhaps I need a new approach

[Inky Phil]

This

http://fmforums.com/forum/showtopic.php?tid/187480/post/254753/hl/current/fromsearch/1/#254753

may be of interest to you

Phil