Field Calculation

[fmpuser]

I'm trying to compare Field A with Field B in a Master file, and if the (Text) contents are NOT identical, automatically have the word "Changed" entered into Field C. Field A is a "related" field displaying info from a nother database.

I have tried different calulcation formulas but just can't seem to get the hang of the syntax or something.

HELP!!! Thanks.

[ January 05, 2002: Message edited by: fmpuser ]

[tlsparker]

Define Field C as follows: If( FieldA = FieldB, "Unchanged", "Changed")

Hope this helps!

Tom

[email protected]

[fmpuser]

Tnx, Tom. I tried that suggestion earlier but it doesn't work...perhaps because Field A is a "related" field from another DB?

Someone else sent me this (using my actual field names):

If(QA4Name = RelationshipName: wnerName, "", "Changed")

So I typed in the "RelationshipName", and tried it but it didn't work.

I then put the cursor inside the QA4Name file, clicked Relookup and

here is what that previous mysterious dialog box said:

In the 3 Records that you are browsing, copy new

lookup values based on the name "QA4Name"?

I clicked "OK" and then things worked "OK" again. But I am still VERY

confused as to why this is not working AUTOMATICALLY, and why I have to

click in the "QA4Name" field instead of DifferentFlag, let alone have

to use the "Relookup" function.

Bizarresville.

Eric