Jump to content

Matching text fields


This topic is 6119 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I have a very simple database that uses a last name to match two tables of information together. For some reason I can't get the match to work. I know the data is good because I can copy a name from one table and search for it in another -- I will find a hit on the search. I have tried changing the search on in the text field to unicode rather than English but that doesn't work. No idea what I am doing wrong - makes no sense to me that if Filemaker can find a name from one table in another table, then using those fields to define a relationship should work, if for nothing else but at least those records where the searched names are matching. I'm sure I am doing something stupid but I seem to have tried every permutation! Any help would very much be appreciated.


Link to comment
Share on other sites

I hope this last name match isn't being used as the primary relationship for the database: as you've discovered such things aren't reliable. It gets worse when names have to change. An auto-entered serial number should be used instead.

If you want to make a "match by name" system where matches are listed in a portal, then using last name is good. In this case, look at using the >= operator in the relationship, it will allow partial matches to work.

Link to comment
Share on other sites

This topic is 6119 days old. Please don't post here. Open a new topic instead.

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
  • Create New...

Important Information

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