{b}gCity & "-" & gSuburb & "-" & gSchool & "

Apologies for the Duplicate message not sure what happened there,

I have created my two calc fields

cCalcKey and cIndexedMultiKey, is the relationship cIndexedMultiKey -> cCalcKey?

I do get an warning regards Index can't be done. According to the FMPro help I may create a string to large to Index.

example

"Auckland" & "Manukau" & "Penrose" & "Penrose High School"

quote:

---

Originally posted by byteworks:

I think I get the picture, just one question is the MultiKey field a calcuation using the CASE() statement.

---

Nope. You simply seperate the various key line with the paragraph character.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=

Fasteners_development_09_12_05.zip

quote:

---

Originally posted by byteworks:

Apologies for the Duplicate message not sure what happened there,

I have created my two calc fields

cCalcKey and cIndexedMultiKey, is the relationship cIndexedMultiKey -> cCalcKey?

I do get an warning regards Index can't be done. According to the FMPro help I may create a string to large to Index.

example

"Auckland" & "Manukau" & "Penrose" & "Penrose High School"

---

Your relationship should be from main file -> related file and cCalcKey -> cIndexedMultiKey.

You just have the fields in the oposite files.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=

I have been trying to do this with a self relation (in the same file), I'm assuming this is not suitable.

thanks again.

Put a space " " between your variables. Filemaker will index more of the line because it thinks they are separate words. Also, Go the other way with your relationship. FM can't index a global.

You can do it with a self-relationship.

[This message has been edited by signal (edited March 05, 2001).]

I would like to be able to have a menu selection process which will automatcially filter the data in the related Portal.

Can anyone point me in the right direction, especially samples.

scenario for filter is as follows

City

Suburb

School

thanks in advance

quote:

---

Originally posted by byteworks:

I would like to be able to have a menu selection process which will automatcially filter the data in the related Portal.

Can anyone point me in the right direction, especially samples.

scenario for filter is as follows

City

Suburb

School

thanks in advance

---

Basically you use 3 global fields to store your criteria, and build a calculated key from that: cCalcKey = gCity & "-" & gSuburb & "-" & gSchool.

Then in your related file you need a indexed multi-key:

cIndexedMultiKey =

gCity & "-" & gSuburb & "-" & gSchool & "

FM won't have it,

I have create a dummy DB to work with a self relation but I still get the error

"This relationship will not work due to the field ::cMultiIndexedKey can not be indexed, proceed anyway?"

FM can't index a global

neither of these fields used in the relationship are globals. However the cCalckey field does build it's answer from globals.

quote:

---

Originally posted by byteworks:

FM won't have it,

I have create a dummy DB to work with a self relation but I still get the error

"This relationship will not work due to the field ::cMultiIndexedKey can not be indexed, proceed anyway?"

FM can't index a global

neither of these fields used in the relationship are globals. However the cCalckey field does build it's answer from globals.

---

Ok, you are doing something wrong. It is not FMP. Filemaker can use globals on the left side of the relationship, but not on the right side.

cCalcKey is made up of your global selection criteria and is on the left side of the relationship. It is the "one".

I made an error in my original instructions to you. cIndexedMultiKey is made up of all of your indexed data fields and should be similiar to the following:

City & "-" & Suburb & "-" & School & "

Still no go, I have errors as far as the eye can see, FMP just won't let me do a self relating link which contains Globals.

I have a series of screen shots if anyone is interested?

Database name - test.fp5

Fields

gSchool - text (can't index)

gTown - text (can't index)

cCalcKey - Calc, gSchool & "-" & gTown

cIndexedMultiKey - Calc, (gSchool & "-" & gTown & etc etc)

relationship

name - ShowSchoolsBy {test.fp5 - test.fp5}

match fields cCalcKey - cIndexedMultiKey

result

Don't Work,

Well had a strong Cup of Coffee, a relaxing Snickers bar and hey presto saw my problem.

The calc covering all my options had and extra line with "-" & etc, which wouldn't show up as an error (copy and Paste from prev DB)

once I had scrapped this and started again and planned manually exactly how it should be it worked.

Thanks very much I can sleep know