Ok I need a little help to figure out how I would set this calc

Hi Ret,

Here is a simple file for you to look at.

Lee

Somthing seem to be wrong with the server, I was unalbe to review your attachment.

RET

GetField( "Field" & GetField( "Field4" ) )

Even I am impressed that it works.

Still don't get it ..can you elaborate?

GetField( "name" ) pulls the contents from the field specified in name. So GetField("Field4") retrieves whatever number is in Field4. Then you concatentate "Field" and this number to produce Field1, Field2, or Field3, depending upon what number was in Field4. Then you use GetField() again to retrieve the value from this resulting field.

See attachment for example.

Calc.zip

Hi Queue,

Isn't Get Field a new feature found in Version 6 only? I have version 5.x, and it isn't there, not sure of as I didn't upgrade to 5.5.

Lee

Hi Rit,

You are correct, there is something wrong with the server. I can send it to you direct if you want, just let me know what address.

Lee

Yes, it's in 5.5 My attachment works, but yours doesn't. Maybe try attaching it again?

Or simply:

Field5 = Choose(Field4,Field1,Field2,Field3)

Choose( Field4 - 1, Field1, Field2, Field3 ), since zero is the first condition result.

Oops.

I was able to finally get the file to upload. Click Here

It is the enclosure in my 2nd to last posts.

Lee