How to filtered a Portal ?

[guy tanguay]

Hi

I have a portal of table 1 in table 2 that have a 2 fields critaria relationship. That work fine.

Now, i just want that portal to make appear only the records that are in "Category A"(which is a field that have a Custom values-list) So, filtered-out, all others records that are in others categories.

How can I make a portal filtered some records ?

keep in mind that i whant to still use the basic relationship for others layout / view.

thx

guy

[guy tanguay]

Hi

I have a portal of table 1 in table 2 that have a 2 fields critaria relationship. That work fine.

Now, i just want that portal to make appear only the records that are in "Category A"(which is a field that have a Custom values-list) So, filtered-out, all others records that are in others categories.

How can I make a portal filtered some records ?

keep in mind that i whant to still use the basic relationship for others layout / view.

thx

guy

[guy tanguay]

Hi

I have a portal of table 1 in table 2 that have a 2 fields critaria relationship. That work fine.

Now, i just want that portal to make appear only the records that are in "Category A"(which is a field that have a Custom values-list) So, filtered-out, all others records that are in others categories.

How can I make a portal filtered some records ?

keep in mind that i whant to still use the basic relationship for others layout / view.

thx

guy

[mr_vodka]

Why dont you just create another relationship with another instance of the table. Then you can match only on the values that you want, and use this new relationship for your portal only.

[mr_vodka]

Why dont you just create another relationship with another instance of the table. Then you can match only on the values that you want, and use this new relationship for your portal only.

[mr_vodka]

Why dont you just create another relationship with another instance of the table. Then you can match only on the values that you want, and use this new relationship for your portal only.

[guy tanguay]

Hi John, thanks for your answer

Sorry I am beginner.

Basically, I duplicate table 1 in the graph only (not a new entire table, right?) and I add a criteria betwen this new instance of the graph and table 2 ? But how can i make the match on a specific value ? Ex: field categorie must be "Category A" ?

thx

guy

[guy tanguay]

Hi John, thanks for your answer

Sorry I am beginner.

Basically, I duplicate table 1 in the graph only (not a new entire table, right?) and I add a criteria betwen this new instance of the graph and table 2 ? But how can i make the match on a specific value ? Ex: field categorie must be "Category A" ?

thx

guy

[guy tanguay]

Hi John, thanks for your answer

Sorry I am beginner.

Basically, I duplicate table 1 in the graph only (not a new entire table, right?) and I add a criteria betwen this new instance of the graph and table 2 ? But how can i make the match on a specific value ? Ex: field categorie must be "Category A" ?

thx

guy

[mr_vodka]

You would have another field match as part of your matching criteria. So currently you have two field you match on already. You can create another field that has uses the same value list to populate the field in table one. This would then match to table 2 and show you only the values for "Category A".

[mr_vodka]

You would have another field match as part of your matching criteria. So currently you have two field you match on already. You can create another field that has uses the same value list to populate the field in table one. This would then match to table 2 and show you only the values for "Category A".

[guy tanguay]

Yeah, it would work, but the problem is that:

I want to have 2 Separate Portal of Table1 in the same Layout in Table2.

One will be "CategoryA"

and the Other "CategoryB"

any idea ?

thx

guy

[Oldsneekers]

My understanding is the records in the table have a field "category" and another field. The match field (also known as "key field") is the category field. The values in this match field are "category A" and Category B". You want one portal to show you the list of records where the match field value is "Category A" and another portal to show you the values with the match field of "category B".

If this is true: The match fields for each of the protals could be globals: MFglobA, MFglobB. In the define relationship window: get the TO desired for the portal and relate the MFglobA field to the category field, Define another relationship to the same TO and relate it to MFglobB. Now place the respetive portals on the desired layout. Enter the vaule Category A in the field MFglobA, enter Category B in the the MFglobB field. Ther you have it: two lists from the same TO with the two categories.

Other options: one portal and just toggle the values for the single match field "MFglob".

If I got a little too simple, sorry, but I can still remember when all was Filemaker was Greek to me.

"It's never so bad that it couldn't get worse."

[guy tanguay]

Hey Oldsneekers,

I have try your idea, but i coudn't make it work. So i decided to make a quick FMP7 file of what i am trying to do, so you can better understand what i mean.

the account is "admin" and the password is "open".

Let me know what you think. something a example is worth 1000 words !

thx

guy