Finding Specific Criteria inside the portal

[chadski021]

I have a table name Company and Agent

 

The Main Table is Company and the portal is Agent

 

This is the Relationship

 

Company ID (Auto Serial) == Agent CID (text)

 

In the Main Layout (Company Detail) I have 3 Records

 

In 1st Record

Company Name : Company A

Portal Record (Agent Table): Ana , Karen, Nina

 

 

In 2nd Record

Company Name : Company B

Portal Record (Agent Table): Ren , Akin

 

In 3rd Record

Company Name : Company C

Portal Record (Agent Table): Pao , Meri, Yuna , Key

 

 

My Problem is How can i find a specific Name of agent inside the main layout (Company Detail) in portal

 

For Example i want to find Yuna

 

The Result should be 

Company Name : Company C

Portal Record (Agent Table): Yuna

 

Any Help is appreciated. Thanks for your help in advanced

[jbante]

First, if your company primary key is an auto-enter serial number, why isn't your Agent::id_Company field a number field? I suggest you change it. Number fields have better performance in relationships and finds than text fields, and they have smaller indexes.

 

Now, to answer your actual question. The naive approach would be to simply enter find mode on your Company Detail layout, type "Yuna" into your agent name field in the portal record, and perform that find — this will get slow fast if you have a lot of records. It will be faster if you Perform the find on a layout based on an Agent table occurrence, then Go to Related Records to get your found set of Companies on the Company Detail layout.

[LenLen]

Hello

 

I have the same problem like this. When i find a specific criteria inside the portal it will show but the it also show the other data inside that portal.

 

For Example in my portal we have dog, cat, lion and cow when i find only dog the result inside the portal are dog, cat, lion and cow. i need to show only the dog inside the portal.

 

Can someone help me or guide me how to solve my problem step by step. I am just new to FileMaker Thank you in advance. 

[comment]

That is how portals work: they show the related records and ignore any finds you may perform.

In your example, you should perform the find in the child (Animals?) table. You can place fields from the parent (Owners?) table on the layout. If a person can own more than one dog, use a sub-summary part to show the owner's details.

[LenLen]

Hello Comment thank you for your reply How can i do this?

 

"You can place fields from the parent (Owners?) table on the layout. If a person can own more than one dog, use a sub-summary part to show the owner's details."

 

Can you guide me how to do this step by step? 

 

What is the first step i need to do?

 

Sorry I'm just new FileMaker