FMP 9 + Windows XP

Hi

I am trying to have certain contacts show up in my project table.

The contact is categorized eg:

Name John Doe
Category1 = Freelance
Category2 = Photography
DesignStyle = Corporate, Traditional, Contemporary etc...

I want to be able to show up John Doe in my portal (along with any
others who match the criteria) in the Project table when I set the
fields in Project to:
DesignStyle = Corporate
Category2 = Photography

To set this info into Contacts via a portal I set another Table called
DesignStyle to store the
Name, Category2 and DesignStyle

To show this info in a portal in the Project table I made a
relationship from
DesignStyle and Project
set with criteria
Category2 = Category2
AND
DesignStyle = DesignStyle

I can not get this information to show up in the portal, I have been
testing for days and cannot work out what I have done wrong!

Please help.

Toni

On Jul 29, 5:40 am, tm <eshopst... [at] optusnet.com.au> wrote:
> FMP 9 + Windows XP
>
> Hi
>
> I am trying to have certain contacts show up in my project table.
>
> The contact is categorized eg:
>
> Name John Doe
> Category1 = Freelance
> Category2 = Photography
> DesignStyle = Corporate, Traditional, Contemporary etc...
>
> I want to be able to show up John Doe in my portal (along with any
> others who match the criteria) in the Project table when I set the
> fields in Project to:
> DesignStyle = Corporate
> Category2 = Photography
>
> To set this info into Contacts via a portal I set another Table called
> DesignStyle to store the
> Name, Category2 and DesignStyle
>
> To show this info in a portal in the Project table I made a
> relationship from
> DesignStyle and Project
> set with criteria
> Category2 = Category2
> AND
> DesignStyle = DesignStyle
>
> I can not get this information to show up in the portal, I have been
> testing for days and cannot work out what I have done wrong!
>
> Please help.
>
> Toni

You don't need the table Design Style. You just want to relate
Contact to Project. So have the relationship be:

Contact::Category2 = Project::Category2
Contact::DesignStyle = Project::DesginStyle


G