Jump to content
Sign in to follow this  
Lee J

Portal Filtering

Recommended Posts

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"

Share this post


Link to post
Share on other sites

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:FmPro@home.com

http://www.database-resources.com

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

Fasteners_development_09_12_05.zip

Share this post


Link to post
Share on other sites

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:FmPro@home.com

http://www.database-resources.com

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

Share this post


Link to post
Share on other sites

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

thanks again.

Share this post


Link to post
Share on other sites

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).]

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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 & "

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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 & "

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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, frown.gif

Share this post


Link to post
Share on other sites

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 smile.gif

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    Christoph 
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.