How would i go about having a field automatically populate itself with a unique id # ONLY when 2 other fields actually contain data. Any way of doing this by a calculation or am i looking at writing scripts.

Any help is much appreciated.

....Haps93

Auto-enter, by calculation,

Case (not IsEmpty(field1) and not IsEmpty(field2), serial ID field, "")

Serial ID is a separate auto-entered serial number field.

Fenton's meth wil work but will skip numbers when the fields are populated (if thats a problem,

Try auto entering

Case (not IsEmpty(field1) and not IsEmpty(field2), max(UniqueIDField)+1 , "")

That way all id's will be sequential if needed.

If the ID' is justed used as a key then Fenton's methode will be faster.

Charles

Thanks Guys, i figured it was an easy task , just couldn't get my head around it.

....Haps93