Combining 2 fields for a unique id number

[kathyba]

Hi,

How would I do the following:

populate a field (Project number) with elements of a last name field, the date, and a sequential number starting with 1.

For example, the first project for SMITH would be SMITH_050304_01, first project for MICKIEWICZ would be MICKI_050304_01.

Then if there was already a project number with that code, it would add "02" to the name.

Is this possible?

Kathy

Maine Historical Society

[Damocles]

Here is an example that uses "year" and "Weekofyear" rather than LastName and Date. It does the incrementing, though.

http://www.fmforums.com/threads/download.php?Number=103594

You might want to do a search of previous posts for "secuencial field" (include the quotes) in the subject line. There is a solution posted by -Queue- that works well, along with accompanying explanation.

Paul