Strange scenario in my solution...I have a db that was written in FMP7 and we are now on FMP8 (server advanced).

Table: Reports

Field course_name = calculation of courses::course_name_long (text)

Table: courses

Field: course_name_long = text field

I have a layout based on the Reports table with several fields. When I do a find on the calculated field "course_name", I always get the entire database as my found set. It acts as if I've searched for "*". The field displays correctly on the layout with the proper related value, I just can't search on it.

This seems to happen with any field that is a calculation from a different table.

If I make a test field in Reports (text) and manually replace it's contents with the related field values, I can search it with the correct results.

Any ideas? It used to work in FMP7.

I just found that this happens when moving a solution from FMP7 to FMP8. I created a test database (attached) in FMP7. Searching works fine.

I then moved the solution to our FMP8 server (advanced) and opened the hosted database. I attempt to do the search (FMP8 advanced) and it returns all rows.

Anyone else encounter this issue? My previous FMP7 solution is 75% dependant on this type of searching. Please help!

mytest.zip

8.0v3 was supposed to have fixed this problem. Have you ran the updater?

This is a known issue in FileMaker 8v2 and any prior version connecting to Server 8v2.

Try updating client and/or server to 8v3.

Ah ha! I'll look for the v3 patch! Whew! I must admit, I was pretty nervous there!

Thank you, thank you, thank you!