I need a field to Enter a # starting with 1...no big deal huh.

So I have two feilds. Job_number and Change_number.

Change_number is the feild that will need to change on creation of the record. It needs to look to see if there is a record or records with the same job # and add 1 from the higest Change_number of the same job #. If there is no other record with the same job # then it needs to be 1.

Example

===============

1st record

Job_number = 100

Change_notice = 1

2nd record

Job_number = 200

Change_notice = 1

3rd record

Job_number = 100

Change_notice = 2

4th record

Job_number = 100

Change_notice = 3

Thanks

Devin

Create a relationship based on JobNumber. I'll call it PreviousJob. Sort the relationship by Change_Notice, descending. Then change Change_Notice to be an auto-entered calculation (leave 'do no replace existing value' selected) of

If( not IsEmpty(JobNumber); PreviousJob::Change_Notice + 1 )

Thats it....Thank you

I had the relationship part done, but not the calc.

Devin