Dear All,

I would like to a create a value list that contains 'standard' rows as
well as rows drawn from a relationship i.e.

Menu Items Table:

Lunch Chicken
Lunch Noodles
Dinner Fish
Dinner Beef
Standard Rolls
Standard Tea

If in a Menus table I select Dinner I want to show in my items popup
list Fish, Beef, Rolls & Tea, similarly if I select Lunch I want to
show Chicken, Noodles, Rolls & Tea. How is it possible to add the
additional 'Standard' catagory.

Thanks for your help

Chris

On May 6, 6:13 pm, "chris_w... (AT) silverbirches (DOT) com.hk"
<chris_w... (AT) silverbirches (DOT) com.hk> wrote:
here are a couple ways: (the capital P refers to the newline symbol,
the "Paragraph" marker in filemaker.)

1) duplicate the rolls and tea data once for lunch and once for
dinner. Its clumsy but effective, and simple.

2) instead of "standard", put in the 2 lines:
dinnerPlunch

It will act as a multiline key, and match both lunch and dinner

3) define a stored index calc field:
keyfield = if(categoryfield = "Standard";
"DinnerPLunch";categoryfield)
and use the calc as the relationship key. It basically the same as 2
above, but lets you retain the 'Lunch, Dinner, and Standard' values.

4) currently you've got a 'lunch or dinner' field, that the user
selects, that drives the relationship. define an unstored calc based
on that:
matchfield = selectionfield & "PStandard"
and define the relationship based on this.

This accomplishes the same thing as 2 or 3 above, except moves the
multiline key to the other side of the relationship.

There is no best solution, although I'd say #4 is better than #3 in
most cases.

-cheers,
Dave