Find does not work in my portal field

[snekkis]

Is it possible to make a find in a portal? I have a portal in a master with one field from a related file. It shows all the record from that related file, but when I try to make a find in that one related field/portal/find mode, it says "No records match this request"

[djgogi]

check this article for more info on find thru portals.

dj

[snekkis]

dj,

Sorry, I'm not grasping what your 're meaning! Is Parent and Child meaning respectively Master and Related file? Or is Parent and Child the names for the record respectively in the Master and Related file. Actually, I don't want to think about that. I believe there must be alot of confusion here, but if I try to draw hierarchical for you how fields and relationship is:

Master file // I call the relationshipfield here, masterRel

Layout

masterRel

Portal [ ::relatedfield]

Related file // I call the relationshipfield here, relatedRel

Layout

relatedRel // In this file all the fields have same ID to show in Master file portal

relatedfield

What I have tried to do out from your article, was to put the masterRel field and the relatedRel field inside the Portal and then perform the find inside the relatedfield. It is in the relatedfield fields I want the find from, and to show inside the Portal.

Where do I put my fields and how do I do the find? I still don't get it.

[Lee Smith]

Parent = Master, Current (Current = FileMaker's term)

Child = Related, slave, (Related = FileMaker's term)

Also, there are other words used for Current and Related.

HTH

Lee

[LiveOak]

Just to be clear. When you enter find mode, type something into a portal row, and perform a find, you find all the records in the current file with the item you typed on a portal row. If you want to find records in the file displayed in the portal, you must perform the find in the related file.

I think what you were expecting is to find all the records in the related file with that value, doesn't happen.

-bd

[snekkis]

What a turn off!

Well, I see no other option than to put all the records of the related file inside the master then. A solution I'm building is based upon this function I'm trying to make.

But then, is there any limit of how many records a file can take?

[Ugo DI LUCA]

If you often use the same search, create a few global fields and a search layout in your file.

Then define some relationships from your Main file to the related file using globals::related records. Then use a script Go to Related Records and use a portal in your related field to display the result of your find.

What I'm actually doing within my Invoice File can give you an example :

Looking for all Invoices with same product_ID

In Invoice File :

A c_Hook field (index calculation = 1)

A n_Hook fied (number =1)

A global field g_ProductID

In Line Item :

A global Number g_Hook = 1

A number field n_showallinvoices.

A global field g_InvoiceID

A relationship Search ---> Invoices:g_Product_ID::LineItem::Product_ID

A relationship Constant ---> Line Item:g_Hook::Invoice:c_Hook

A relationship Line Item:InvoiceID::Invoice:InvoiceID

A relationship Back to Invoice ---->Line Item:g_InvoiceID::Invoices:InvoiceID

A relationship Back to Lines ---->Invoices:n_showallinvoices1::Line Item:n_showallinvoices1

A relationship Show All Invoices ---->Line Item:n_showallinvoices1::Invoices:n_showallinvoices1

A selfjoin in Line Item ---->Line Item: g_Hook::Line Item:n_showallinvoices1

I have a Search Layout with all globals and a button next to the field to perform find.

When entering the Product I'm looking for, the script goes :

Go to Related Record : Line Item,

Set Field (g_InvoiceID,Contant::InvoiceID),

Perform External Script (loop through records related in Line Item and set n_showInvoices to "1" if Is not Empty Invoice N

[snekkis]

Thanks Ugo, that was some workaround!

I have to sit down and see if this function is relative to the rest of what I try to accomplish.

[Ugo DI LUCA]

Hi Snekkis,

One correction to the post above.

Of course, if you do not need Layout X, you can directly go to the last loop script.Took me 3 seconds to have listed 25 invoices with same Product_ID running FMPro5.5 and MacOS8.6.

It took me 24 hours to see that my 3 second script was a stupid idea. If I want to have listed all invoices that have Product A in it, I just have to enter Product A in the Portal row, then switch to list mode.

I have invoices with more than 50 items in each. When seraching for this product in the portal, it is not that easy to locate the item if there are 40 invoices and many lines, as all records will appear. That is why I use the method above (except the last loop script).

Now looking back to your first post, I think there could be several reason why you have this message, from which :

1. Your portal use a contant relationship (global = 1 :: indexed calculation = 1). Then use another portal with another relationship for your find, or the related field based on another relationship.

2. You are looking for a calculation field but while it is formated to display as 12,50$, it's real result is 12,50125$.