Is there a way to get a calculation to enter text into a third field?

i want my calculation to do this:

if(field1=x, "y" & field2="y", If(field1=a, "b" & field2="b", If(isempy(field2), "q", "r"

Field 2 is a regular text (name) field that has valid text entries and i want to display "y" in the calculation field and replace any text in field2 with "y" if field1="x".

Same idea for the second "if", and if by the third "if," field2 is still empty, display "q"; and when i put a name into field2 display "r".

is this possible?

i hope my explanation isn't too confusing...if anyone would like a more detailed explaination, send me and email and i'll try to be more specific.

Hi Slaughter.

I'm not entirely clear on what you're trying to do, but a possible solution is to set up Field2 as a lookup, based upon the value in your calculation field.

I read something about this somewhere else in the forum - can't remember where - but it might give you something to play with, at least.

Paul

Seems to me (and your post is a bit confusing) that the calc for field3 is pretty straightforward -- nested If statements (which could probably be replaced by "Case" statements, but it still works your way). The problem seems to be replacing the contents of Field2 based on the entry in Field1.

If this is so, I suggest having an entry field for Field2, and a calc Field2 (call it "Field2_calc"). "Field2_calc" would equal "Y" if Field1="x", "b" if Field1="a", or else it would equal Field2.

You can also place Field2_calc on top of Field2 and delect "Allow entry into this field". That way, when you click on it, you'll actually get Field2 (which may or may not be important, depending on the contents of Field1.

Hope this is less confusing,

Dan