I've been trying to find a solution to this problem so this is my next big idea.

I've got 3 main fields for this problem.

Filed A, Filed B and Filed C

"Filed A" and "Filed B" is a user input filed, while "Filed C" needs to be a auto-enter calculation I think..

"Filed C" is a serial Number

So in english this is what I want it to do.

If "Filed B" has a value then use that vaule and find the Record for "Filed A" that matches and input the Value From "Filed C" of the found record. If filed B is blank then enter the the next serial # value and it must be unique.

So what I wanted to do is to be able to find certian jobs that our common. It's more like your avarege chain or chains, each chain is made up of of several links (or records), but there are several chains that have nothing to do with each other.

Thanks

Devin

If "Filed B" has a value then use that vaule and find the Record for "Filed A" that matches and input the Value From "Filed C" of the found record.

Can you explain this some more? Use the value of Field B for what? What is the criteria for matching? Is it Field A = Field A and Field B = Field B?

Can you explain this some more? Use the value of Field B for what? What is the criteria for matching? Is it Field A = Field A and Field B = Field B?

Here my working test job!

The Fields are the Job # and Previous Job# and Job ID.

The Job # and Previous job# are the fields that we enter.

The Job ID at this time is an auto-enter serial # but then we go back and change it to the the Previous job # ID if there is one.

I would like this to happen with some form of calc or script if there is a Previous #.

This allows me to see in the portal the job history.

If there is a better way then I'm all for it.

Thanks

Devin

Archive.zip