Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

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

Recommended Posts

  • Newbies
Posted

Hi, I was using filemaker 2.1 on a MAC and recently installed Filemaker Pro 5.5 on my PC. I am just starting to create my database and already I ran into a problem. When I do a lookup for one word in a field of multiple words, I am not able to get the result back. It seems I need to do a looku for the entire text in the field. Let's say the field I'm doing a lookup in contains the following: "Danny Price" I can't seem to do a lookup on Danny itself or Price, I need to do a lookup for Danny Price to get a result back. How can I fix that problem? I never had to specify anything special in FM PRo 2.1. Thanks for your help.

Posted

Lookup are now based upon relatonships and keys. Relationships require and exact match between the keys used in the relationship.

The way you "fix" this is to modify the design of your database to not use things a vague as names a keys. More appropriate would be to create and use a ContactID or CustomerID (as appropriate) and use a drop down value list showing both CustomerID and Customer Name for selections. All new features since 2.1.

OBTW, cranks are gone from the front of cars too... wink.gif

-bd

This topic is 7861 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.