Jump to content
The site is updated on a beta version. Maintenance tasks are running so search and index may not function at this time. ×

Recommended Posts

14 minutes ago, Wim Decorte said:

And you can search directly on that field.  If you are not familiar with related searches then experiment a bit with it until you are comfortable with it.

So, basically, in a nutshell: If I just have a relationship setup and use that related field on the layout, I'm forever going to see the oldest entry ever made under that relationship listed there unless I've got some sorting method applied in that layout or to that relationship?

First <--> Oldest, meaning if I add 0, 1, 2, 3, entries .. and at a later date delete 1 & 2, add a 4, 5, 6... that 3 being the oldest in the relationship at that point would be the one I would see in that field?

This part should be a different thread anyway.

Link to post
Share on other sites
  • Replies 5
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Only a sort in the relationship definition would change what related record shows up.  Not any kind of sorting of the parent records (the layout).

And yes: in the example you give, #3 would be the one show since it is the oldest surviving one in creation order after you delete #1 and #2.

Link to post
Share on other sites
2 hours ago, Tony Diaz said:

I'm forever going to see the oldest entry ever made under that relationship listed there

Yes -  but since your title is "related searches" it should be clarified that searching the child field will search in all child records, not just the first ones. 


Link to post
Share on other sites

Yes.. I understand that .. a found record from any of those results would not necessarily show the found result on the layout if the matched data is in a field not programmed to show on the layout.

That's what pop-overs and "hide if" scripting on the layout. :)

Link to post
Share on other sites

Good distinction to keep in mind.

Searching on a related field will yield a found set of all parents records who have a matching related record among all its related records.  Not parents where the first related record matches.

Visually that may throw you off if you don't show a portal of all related records.

Of course if you want to do a search where only the 'main' (aka first) publisher matches then you can loop through the initial found set after doing the search and omit the ones where that first related record doesn't match.

2 minutes ago, Tony Diaz said:

a found record from any of those results would not necessarily show the found result on the layout if the matched data is in a field not programmed to show on the layout.

I don't think I follow what you're saying here.  If you do a search from a layout and there are no scripts or triggers involved that would change the layout then the found set will be in the layout you did the search on.  Whether you search in a field that belongs to the TO that the layout is based on, or a related field.  If you are on a layout for books you will always get a found set of books, even if you search the related publishers field.

Link to post
Share on other sites

I mean that if I search for a value in that related table that happens to be newer, that the record when loaded may not show me that value if I'm only seeing the oldest related value, as mentioned previously.

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Similar Content

    • By GAltanis
      Dear users,
      I have three tables for three relevant layouts. Each one has separate table and tables are related with only one field.
      The scope is to show on the 2nd and 3rd layout the records that related with the 1st one. Here are some screen shots with what I need to do. Actually, I need to have on the seconf layout ("Orders from suppliers") the related records from the first one ("Suppliers list")
      Thank you thank you


    • By epatrick
      I find it odd that FileMaker is so intuitive yet hides access to the file name of the data source during importing. It looks like the only way I have found based on posts on the forum is to import the Data Source file as a reference into a container field. That is an extra step that shouldn't have to be done since FileMaker sees the Source file name during multiple points in the import process. Here are three dialogs where it's seen during import. There has to be a way to use the input file name with some kind of Get Function.  Please help!

    • By 34South
      I previously used ODBC Manager (32 bit)  to great success importing data directly from Filemaker Server to JMP. I recently upgraded to Catalina (MacOS 10.15.5) and knew that one of the casualties would be this ODBC utility. I downloaded the 64 bit ODBC manager from Actual Technologies and successfully installed it but get the following message when trying to open an FM database from within the ODBC interface in JMP:
      dlopen(/Library/ODBC/FileMaker ODBC.bundle/Contents/MacOS/fmodbc.so, 6): image not found
      I have navigated to Actual Technologies' web site believing I should download an ODBC driver but this comes at a hefty price tag, especially when converted to my local currency. Given the increasing costs of maintenance contracts and SSL certificates I had hoped to avoid further expenditure. Do I really need this and is there an alternative?
    • By droid
      I've been saving various files - mostly pdfs - in FM container fields, for years. A script triggered by clicking in the field allowed the field to be exported for viewing.
      Recently I upgraded to FM18, and now when I click in the field, I'm told "container fields cannot be exported"!
      Is there a new way that I should be doing this? Thanks.
    • By ggt667
      I can ping my PDF document server from Terminal, I can connect to the PDF document server from all browsers apart from Safari, my default web browser is FireFox, I also tried to change to Chromium and Opera as the default web browser. WebViewer has the same symptoms as Safari, server not found.
      $ ping -nc 1 document PING document ( 56 data bytes 64 bytes from icmp_seq=0 ttl=64 time=0.002 ms --- document ping statistics --- 1 packets transmitted, 1 packets received, 0.0% packet loss round-trip min/avg/max/stddev = 0.002/0.002/0.002/0.000 ms FileMaker says ’Couldnot connect to the server.’
      The issues is easily solved by creating a new MacOS X user, and log in to that user, however I would rather like to fix the current user not having to migrate all other application settings. Is there some dns cache specific to Web Viewer and Safari?
  • Who Viewed the Topic

    12 members have viewed this topic:
    PedroAlex  Matt.C  Rich  Fitch  doughemi  _ian  OlgerDiekstra  JLF  Rick Whitelaw  Lee Smith  rick altman  dansmith65 

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.