March 17, 200520 yr 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
March 17, 200520 yr Author 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
March 17, 200520 yr Author 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
March 18, 200520 yr 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.
March 18, 200520 yr 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.
March 18, 200520 yr 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.
March 18, 200520 yr Author 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
March 18, 200520 yr Author 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
March 18, 200520 yr Author 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
March 21, 200520 yr 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".
March 21, 200520 yr 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".
March 24, 200520 yr Author 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
March 25, 200520 yr 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."
March 30, 200520 yr Author 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
Create an account or sign in to comment