Showing related records in portal

[vlech]

Hi everybody,

Would you please help me to solve a problem with relationship and portal. (Sorry, English is not my native language).

There are two files: Category and Clients.

Fields in Category: CatID (Number), CatName (Text)

Fields in Clients: ClientID (Number), ClientName (Text) etc.

I would like to create row of buttons named as categories and a portal in the file Clients. When I click on the button i.e. "Category-1" all records from Clients related to this category should appear in the portal. If "Category-2" is pressed then records related to "Category-2" and so on.

Please explain me what relationship and between what fields should I establish to get records regarding abovementioned criteria.

With kind regards, Vlad.

[BertBoye]

You will need to add one more portal (Portal 1) and make relation to category with a global filed in

[vlech]

Unfortunately, I could not understand.

[BertBoye]

Have a look on the attachement

Example.zip