FMP 9 Windows XP

Hello

I know what I am trying to do here is simple but it is eluding me.

In my first table Contacts they are categoried twice
Category 1 = Client Supplier Freelance
If the contact is a Freelance we categorise further
Category 2 = Big Small Little Huge

In my second table Projects when I select the Category 2 and it
matches any selection be it Big or Big Small Huge or Small Huge etc I
want all the Freelancer/s name to show up in my portal

I think it has something to do with the Category 2 being a checkbox
and the relationship looking at one match. How can I get it to bring
the name over by picking ANY match in the Category 2.

Thanks so much for any help.

Toni

In article <1185510734.030556.284500 [at] j4g2000prf.googlegroups.com>
tm<eshopstall [at] optusnet.com.au> wrote:
> FMP 9 Windows XP

> Hello

> I know what I am trying to do here is simple but it is eluding me.

> In my first table Contacts they are categoried twice
> Category 1 = Client Supplier Freelance
> If the contact is a Freelance we categorise further
> Category 2 = Big Small Little Huge

> In my second table Projects when I select the Category 2 and it
> matches any selection be it Big or Big Small Huge or Small Huge etc
> Iwant all the Freelancer/s name to show up in my portal

> I think it has something to do with the Category 2 being a checkbox
> and the relationship looking at one match. How can I get it to
> bringthe name over by picking ANY match in the Category 2.

> Thanks so much for any help.

> Toni

It sounds like you already know that the relationship can't be based
on just Category 2.

Change the Relationship (click the box in the line connecting the
tables in the Relationship Graph) so that both criteria have to be
met: Category 1 = Category 1 AND Category 2 = Category 2.Matt

--
Free FileMaker Technique Demos: http://www.VirtualVermont.com/FMP

My Custom Functions: http://www.briandunning.com/filemaker-custom-functions/resul ts.php?keyword=wills