Upgraded to Filemaker 5.5, F*****G lookups

[etcinfo]

I can'T get the lookups to work with FM 5.5 It was so easy with the old version of FM. Anyone has a good link or document to explain how the relation works now? Thanks guys

[LiveOak]

What version of FM did you upgrade from?

-bd

[etcinfo]

Sorry, I should have specified, I went from Filemaker 2.1 (MAC) to Filemaker 5.5 (PC). I activated appleshare on my Windows Server 2000 and got the Files from my MAC. The integrity of my files and fields are Ok but the lookups aren't working. I also tried to create new relationship, value fields and lists, just for testong purposes, but It just doesn't seem to work.

[Lee Smith]

So let me see if I have this right.

You just jumped at least 4 major upgrades of FileMaker, and changed platforms from Mac to Win, and, you stated "I can't get the lookups to work with FM 5.5 It was so easy with the old version of FM."

and then went on to say

"The integrity of my files and fields are Ok but the lookups aren't working."

and then said this

"I activated appleshare on my Windows Server 2000 and got the Files from my MAC."

Wow, I'm surprised that this was all that broke.

Did you try the Relookup manually to see if that works on either of the relationship?

Are these files being served?

Sorry I'm not helping you much, but I am really surprised that that was all that broke.

Lee

[Kurt Knippel]

You went from a Flat File version (2.1) to a relational version, I would suspect that some thing will not work anymore. You may need to get your files into thier final destination (i.e. FM Server or on your local machine) and then redefine the lookups.

Most likely what happened is that either the way 2.1 stores the lookup information is different, or that now since your files are in a new location w/ new names, IP, OS, etc Filemaker is unable to resolve the location and so the lookup does nothing.

[etcinfo]

That's what I'm having problems with, migrating from a flat file version to a relational version. I did a basic test of having a list of names and try to do a lookup of one of those names. Let's say I have a template with the names: John Wolf, Steve Irwin. If I do a lookup for Steve, John or one of the last name, it doesn't find it but if I do it with the Entire name (Steve Irwin) it does find it. That isn't really a helpfull lookup, might as well type everything all the time.

[Kurt Knippel]

Well you need to redefine how you do lookups.

Assuming the following:

FirstName

LastName

cEntireName = FirstName & " " & LastName

Define 2 relationships:

Self by Last Name as FirstName::FirstName

Self by First Name as LastName::LastName

Now setup the lookups based upon those relationships. The FirstName field should lookup the First Name, through the LastName relationship, so that when you fill in a last name it looks up the first name. The LastName field should lookup the Last Name, through the FirstName relationship, so that when you fill in a first name it looks up the last name.

[etcinfo]

Ok, Let's say I have a Database of 3 files. All I have in the files is one filed of Names and I have 3 different Names (John Leclerc, Wayne Gretzki, Patrick Roy). On another Database, I have a field called lookup. How can I type in the first name in the Lookup field and have the entire name appear when I press Tab?:

[Fitch]

1. Define a relationship in "another Database" that is First Name on the left and right side of the relationship.

2. In Define Fields, for your Full Name field, specify this relationship in the Lookup dialog.

In the old FileMaker days, you didn't have to specify a relationship to do a lookup. Now you do.