Portal record display by value list?

[Chalkster]

I have attached a basic file to try and illustrate what I am aiming for.

I have a table "ZONES" containing zones of citiy and aiport codes as specified by each airline... a zone may consist of anything from one to unlimited number of these three letter groups.

Fields are

zone code (unique)

airline (two letter code of the airline for this zone record)

name (free text0

TLC'c (the three letter codes within the zone)

Notes (free text)

g_id for creating the relationship to view zones.

g_airline for the view by airline relationship

It is setup so that clicking on a zone line in the portal displays the record on the right

In the file I have two layouts... one that displays all records from the zones table in the portal, irrespective of airline, Clicking on a zone brings it up the selected record on the right. The second layout displays only those records specified by the value set for the g_airline field above the portal except that I cannot display all records using the "ALL" value in the list as I would like

That is the problem.. I can display either by airline OR all records irrespective of airline... but I want if possible to use one layout that combines both so that if airline is blank or set to ALL then all records show but if airline option is used then only those records for the selected airline are displayed in the portal.

Is it possible to create one layout with a portal that can view selectively or show all?., if so what changes would i need to make to this example? Or am i stuck with having to create multitudes of extra layouts?

FBD.zip

[comment]

See if the attached does what you want.

FBD.fp7.zip

[Chalkster]

Yes exactly what i was looking for... thanks.

Can you explain exactly how it works... i have a vague idea... but what is the significance of the calculated field "cairline" calculation

airline &

[comment]

A match field with multiple lines (often referred to as a multi-line key) creates an OR relationship.

For example, if Table A has 3 records with the following values in the match field:

1

2

3

and Table B has a record with this multi-line key:

1 &

[MoonShadow]

Is there any way to use "All" with a value list based upon values from field?

I'm putting together several VLs for filtering portals. Some are based upon values from field but should include 'All' but it's causing me grief. Your demo is very helpful but it's a bit limited (for my use) by the Custom VL part.

Can you show example using value from field on maybe 2 or 3 value lists to their corresponding fields? If someone doesn't make ANY selection from the VL, the whole thing breaks. Do I use a "None" ? I can't get 'not equal' to work on text.

7 seems great on multiple join fields but if any don't match, it quits working. There is something I can't figure out.

[Chalkster]

Thanks... that explains it... I had wondered if such things were possible (hence my original question, but didnt know the methodology)... the light has dawned:)

[comment]

The same technique can be used with VLs based on fields - see attached. Alas, I have not found a way to insert a separator.

I am not sure what you mean in the second part. Usually, if you use a "not equal" join, you want to have a dummy value on the left side, so it's never empty. Even a carriage return will suffice.

enhancedVL.fp7.zip