Jump to content

Portal Filtering


Lee J
 Share

This topic is 7530 days old. Please don't post here. Open a new topic instead.

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"

Link to comment
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:[email protected]

http://www.database-resources.com

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

Fasteners_development_09_12_05.zip

Link to comment
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:[email protected]

http://www.database-resources.com

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

Link to comment
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).]

Link to comment
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

Link to comment
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 & "

Link to comment
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.

Link to comment
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 & "

Link to comment
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

Link to comment
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

Link to comment
Share on other sites

This topic is 7530 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Who Viewed the Topic

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

Important Information

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