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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  


Important Information

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