Help me to get this relationship to work (indexing)

[SteveGriff]

Hi there. I have this relationship. It is pretty easy to understand, but it wont work because my calculation field cannot be indexed because it references a field from another db.

Here is the relationship: -

Client Database::Contact_Calc - REL - Contact_History_DB::Contact_Calc2

Client Database::Contact_Calc field

Contacted_Date_Sort & " " & Originator_Sort

Contact_History_DB::Contact_Calc2 field

Contact_Date & " " & case(Client_Database_ Rel::Originator_Sort = "All"; "All"; Originator)

As you can see, the Contact_Calc2 field cannot be indexed because it uses a relationship field. Basically, if the Originator_Sort field has "All" (view all Originators of that date).

Client_Database_Rel is a basic relationship of 1 - REL - 1 to view all Clients.

So, in conclusion, I want all Originators when "All" is the contents in the Originator_Sort field. That what the case checks.

I hope this makes sense...

Steve Griff

[andygaunt]

Steve,

not sure if this is what you want but check this earlier post.

It might be the kind of thing you are looking for.

http://www.fmforums.com/ubb/ultimatebb.php?ubb=get_topic;f=17;t=000374

[Vaughan]

Use a lookup to get around the unstored value problem. Be aware that the looked-up value won't change if the "related" value that generates it is modified.

[SteveGriff]

Andy!

Yep, that's exactly what I need!

Hip hip ho ho doo da do

[andygaunt]

Steve,

A pleasure. I think you might have gotten a little over excited back there though.

Still, whatever gets you going!

I think all it needed was,

Hip hip ho doo da do

[danjacoby]

Well, gee, Andy,

So many of us have so many relationship problems, whenever we actually end up with a good relationship it's quite a feeling. I don't think that is at all excessive; I'm sure that I'd have a similar reaction ...

If only I could solve my relationship troubles.

[andygaunt]

Dan,

I agree that

wasn't excessive.

I was just playing when I said I thought it only needed one ho!

I am always happy when someone manages to solve a problem from the experts found in this forum.

Anyway, this is the second or third time you have mentioned your relationship problems.

Wanna talk about it?

Have you tried to compound the multikey with a concatenating response!!!

(Even I don't understand that! )

[ March 08, 2002, 05:08 AM: Message edited by: Andy Gaunt ]

[danjacoby]

quote:

---

Originally posted by Andy Gaunt:

Dan,

Anyway, this is the second or third time you have mentioned your relationship problems.

Wanna talk about it?

---

Well, doctor, it all began when my parents...

[andygaunt]

quote:

---

Well, doctor, it all began when my parents...

---

Hmmmm...yes, I understand.

Now, don't you feel better for talking about this!

The doctor will see you know. Opening hours are whenever a new message is posted.

If you have filemaker, or personal problems, it seems this could be the place to be.

I think we would need a new category. What to call it though!?!

[danjacoby]

How about "The Tao of Filemaker", or "Zen and the FMP Programmer" ... or (for those of us old enough to understand) "I'm OK, You're OK, Filemaker is OK".

[andygaunt]

Good call Dan, but who should be the administering doctor for this particular section.

I vote Vaughan, or Old Advance Man. We would of course have to have you as an on call doctor...available for those....how shall we say...delicate subjects.

[danjacoby]

quote:

---

Originally posted by Andy Gaunt:

We would of course have to have you as an on call doctor...available for those....how shall we say...delicate subjects.

---

Delicate? Who says I'm delicate?!?

[spankalee]

I think I'm having a very similar prroblem and would like to check out the link that andy posted, but it doesn't work. Is there a new link to the same topic?

Thanks,

Justin