Jump to content
Sign in to follow this  

Search finding wrong items

Recommended Posts

I'm using FM 8.03 and the database is on a server. I have two tables joined: people and address. If do a search for the city with records from the Address table (in other words, not relying on the related table), all is fine.

When I do a seach for city from the people layout, I'll get the correct entries, BUT ALSO I'll get some incorrect entries.

For instance, when I search for first name beginning with P, and in London, I'll get some people from Glasgow, Birmingham, and various other cities.

But when I did a test field using the Address table, then all was fine - so it has something to do with the linking between tables.

This works the same whether it is a manual search or with a script.


As always, all assistance is much appreciated.

Share this post

Link to post
Share on other sites

How are your tables related?

Share this post

Link to post
Share on other sites

If a given record has multiple related records, then the search will bring those as part of the found set.

So if the record with the name "Jenny" is related to the cities "London" and "Birmingham", but only "London" is visible through a related field, a search for "Birmingham" will still bring up Jenny's record.

Make sense?

I would recommend making a portal on a layout to see if the "incorrect" entries are because of a one (Jenny) to many (London, Birmingham) relationship.

Share this post

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.

Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    Matt Cudmore 
  • Create New...

Important Information

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