I'm using FM6 on Windows.

My challenge is to create relationships that will find all items from
the selected supplier (that's the easy part) as well as the items that
are common to every supplier (that's the challenge?).

has anyone got any suggestions? Thanks for your help.

Tony

Tony wrote:
have a supplier_ID field where users enter "All" for instance? In that
case, you could use a multi-line key. On the left side (suppliers), you
just need to create a new calculation: supplier_ID & "¶" & "all", and
use it as the key to match with the supplier_ID field from the items table.

HTH

I don't think I made my original question clear enough.

I have an order form with a drop down list of products that can be
ordered. The user selects the supplier first and then the product. I'd
like the picklist of products to only show those from the selected
supplier. That's no problem. But there are also products that are
available from every supplier, generic products, and like these to be
on each picklist too? (I could simply have duplicate records for each
supplier name, but this would blow out to a lot of duplicates).

Thanks,

Tony


Marc-André Paiement wrote:

Well, technically you would have a join table in which all the suppliers for
any given product are listed, even if that seems like a lot of "duplication"
it would ideally be just two IDs (product & supplier).

But let's suppose that you have "All" (and presumably some ID code for All)
listed as a supplier.

What you essentially want to do is to create an "or" relationship.

This is possible if you append "All" (or the ID number for the "All"
supplier) to the key field you're using as the basis of the relationship...
either in a return-delimited fashion, or using repeating fields. FileMaker
will then match you up on either the specific supplier or the "All"
supplier.

"Tony" <ajhanks (AT) midcoast (DOT) com.au> wrote

I don't think I made my original question clear enough.

I have an order form with a drop down list of products that can be
ordered. The user selects the supplier first and then the product. I'd
like the picklist of products to only show those from the selected
supplier. That's no problem. But there are also products that are
available from every supplier, generic products, and like these to be
on each picklist too? (I could simply have duplicate records for each
supplier name, but this would blow out to a lot of duplicates).

Thanks,

Tony


Marc-André Paiement wrote: