There is probably a simple solution for this but it is not coming to me at this time.

I would like to have portal to a table that will display the records based on 2 criteria set by the user.

Example

Table 1

Car Model

Color Selection (red, green, blue, all)

Table 2

Car Model

Color

Year

In the main table the user would navigate to the record with the desired car model and then select the desired color [color:red]or All Available Colors. The portal on Table 1 would then display the available cars from Table 2.

No problem setting this up for the model and any one of the color options, but I am having a problem determining how to also offer the "[color:red]All Available Colors" option.

Do you really have two tables? Why?

Typically, a portal is filtered using global fields. In your example, you'd have two: gModel and gColor.

An All Colors choice is possible, but let's get this basic question answered first.

The files that I describe are for example only. My actual application has multiple tables and multiple files.

I understand that global fields would be used for filtering, but how do I offer the option to see all records through the portal. I have attached a file that illustrates my problem. How do I get the option for "All" to work?

Attachments are not working at the moment, but in general there are two ways to do this:

1. Define a calculation field in the child table =

Category & "¶All"

and use it as the matchfield instead of Category.

2. Define a calculation field in the parent table that returns either the contents of the global selection field or ValueListItems() of your value list, based on the selection.

Another option is to use checkboxes for the selection and - if the number of choices is large - provide buttons for "Select All" (i.e. set the field to ValueListItems) and "Clear All".

By providing that example, however, it suggested that your data model was incorrect. It's much more helpful to post your actual setup.

When I do a Show All in a value list, I put a space before the word Show, so that it sorts to the top.