So I have 2 fmp 6U files, Macrofile and Current. They both have a field called
Semester_uscCard, which is a calcfield combining the two fields of textfield,
Semester like 2007 Spring and a number field, uscCard like 1234567890.

The Semester_uscCard would looks like 2007Spring1234567890.

Also in Macrofile, I have a relationship based on the Semester field. And I have
a field I call "inReadersandJEP", which is supposed to tell me if someone who is
in the Current database is also in the Macrofile database and this is a calcfield:
Case(Semester_uscCard = uscReaders_jep::Semester_uscCard, "Yes", "No")

I would like it to say "Yes" when they do match, and "No" if they do not.

Right now, it always says "No" even though I know of a many matches.

Any ideas what I am doing wrong or what needs to be changed?
--
"... respect, all good works are not done by only good folk. For here, at the
end of all things, we shall do what needs to be done."
--till next time, Jameson Stalanthas Yu -x- <<poetry.dolphins-cove.com>>

~consul wrote:

I'd test that using a portal or GTRR.

If the relation works, I get results using count(relatedtable::key) or
IfEmpty(relatedtabel::key;"No";"Yes").

Good luck. --
http://clk.ch

In article <epe7ot$1g$1 (AT) gist (DOT) usc.edu>,
~consul <consul (AT) INVALIDdolphins-cove (DOT) com> wrote:

Calculation fields generally do not work well as relationship key fields
because they can not be indexed. You can however use a text field that
is filled by calculation to be a reliable relationship key field. You
need to force the field to be recalculated when you change any of the
data that goes into it.

--
For email, change <fake> to <earthlink>
Bill Collins

Christoph Kaufmann wrote:
I went the portal route, I just did it wrong on my first try. Matching field is
uscCard, and I put the calcfield of inReadersandJEP with this calc:
Case(Semester_uscCard = uscReaders_jep::Semester_uscCard, "Yes", "No")
in the same portal, and I get the correct Yes or No answer. Thanks for your help.
--
"... respect, all good works are not done by only good folk. For here, at the
end of all things, we shall do what needs to be done."
--till next time, Jameson Stalanthas Yu -x- <<poetry.dolphins-cove.com>>