More than one portal

[Heathbo]

Is it possible to have more than one portal thats not related in a single layout?

[Søren Dyhr]

Is it possible to have more than one portal thats not related in a single layout?

Huh??? When drawing a portal on a layout makes it filemaker prompt you for a relation to use... I think is one of those questions where you can't avoid telling us what you wish to watch in the layout, and what you would like to accomplish with it.

--sd

[Heathbo]

OK, I have two tables.

Table 1: titled "Cards"

In this table there are fields titled:

"Card Title" - the title of the card

"Card Type" - gives information about what type of card. ie.

baseball, football, comic

"Class" - gives a class assigned to the card ie. good, bad, OK

"cCode" - is a calculation that combines "Card Type" and "Class"

ie. Fgood, Bgood, Cgood, Bbad, Fbad, Cbad, Bok, fok, Cok.

Table 2: titled "Figures"

In this table there a fields titled:

"Figure name" - name of figure

"Class" - gives a class assigned to the figure ie. good, bad, OK

"gFilter_BaseballCard" - a calculation field that takes the class

of the figure and add a "B" to the front of it. ie. Bbad

"gFilter_FootballCard" - a calculation field that takes the class

of the figure and add a "F" to the front of it. ie. Fbad

"gFilter_ComicCard" - a calculation field that takes the class

of the figure and add a "C" to the front of it. ie. Cbad

Using the gFilter fields as my relationship link, I can create a portal in Table 2 "Figures" that will show related cards according to class and type. The problem is, I need 3 portals in one layout in Table 2 "Figures". One for each type of gFilter. I don't know how to create the relationship so each portal will be different.

[SlimJim]

Can't you relate each filter field to the cCode field giving you three relationships which will show the different tyes of card which match the class of the figure. The portals based on these relationships must be disjoint since a card can belong to at most one of them.

[Søren Dyhr]

"cCode" - is a calculation that combines "Card Type" and "Class"

ie. Fgood, Bgood, Cgood, Bbad, Fbad, Cbad, Bok, fok, Cok.

This is not a 7.0'ish way of making a multicriteria relation. Is what you need, a way to make a portal for each cardtype, and have them filled/filtered according to the condition they're in?

So that each portal e.g. shows the bad ones of their category??

--sd

[Heathbo]

This is not a 7.0'ish way of making a multicriteria relation. Is what you need, a way to make a portal for each cardtype, and have them filled/filtered according to the condition they're in?

So that each portal e.g. shows the bad ones of their category??

--sd

That is correct. I need 3 portals in the figure layout. One for Baseball, another for Football, and the other for Comic. In this layout there is the field titled "Class" which tells the you the class of the figure. The 3 portals will then show the cards with matching classes.

For example:

A figure titled "Mcgee" has the word Good in the "Class" field. Thus the three portals will only show cards with good status. So yes, I'm using the cCode field to filter the cards.

Is there a better way of doing this? Because presently I can only get one portal to filter. The others keep listing every card.

[Heathbo]

The portals based on these relationships must be disjoint since a card can belong to at most one of them.

I'm not quite sure what you mean by that.

[SlimJim]

The first relationship: gfilter-BaseballCard match cCode. The only cards that can be related are those where cCode starts with a B, Bgood etc the second relationship gfilter_FootballCard match cCode will pick out all cards in which cCode starts with F so is a disjoint set of cards to the ones where cCode begins with B. Similarly the third relationship gfilter_ComicCard match cCode will relate only the cards where cCode begins with a C.

I'm no expert on relationships involving calculation fields but at a glance there seems no reason why these fields shouldn't be stored and indexed if that is necessary to get the relationships to work.

[Søren Dyhr]

Is there a better way of doing this? Because presently I can only get one portal to filter. The others keep listing every card.

Would you mind wait until tomorrow, and I'll have a template ready for you?

--sd

[Søren Dyhr]

Well something in the vicity of this??

--sd

Cardsfp7.zip

[Heathbo]

Thank you soo much. Thats exactly what I needed. Thats what I love about this Forum. Everybody is always more than helpful.

Thanks again

[Heathbo]

Now lets try to take it a step further. Is it possible to,

1.In the Figures layout add another portal with a pop-up Menu

that only shows the names in one of the portals(in the figure

layout)rather than all the names?

2.Is it then possible to create a field in the same layout(Figures),

that would always read whatever you selected in the pop-up

Menu?

ie. If I selected Mickey Mouse in the pop-up Menu then this

field would automatically read Mickey Mouse. If I changed the

pop-up menu then this field would automatically change to

whatever the pop-up now says.