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

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