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.

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...

-bd