Multi-valuated relationship

[freelancer]

First of all, excuse myself for my bad english...I'll try to explain my problem the best I can.

I am presently converting a database from FM6 to FM7. There is on relation that doesn't work at all in FM7, but used to work fine in FM6.

Here's the situation

I have a Company table and an Employee table. 1 company has many employees. There are 500 company and 3000 enmployees. When the user is in the company list, he has the possibility to consult all the employees related to the "current found" companies. For example, if there are 15 found companies and you press on the "Consult employees" button, you will be taken in the employee table and will see the employees for the 15 companies.

Here's how my relation work :

Company Employee

gAll_Company_Number ------> Company_Number

The field "gAll_Company_Number" contains many company numbers separated by a carriage return. When I ask to see the related records, it finds nothing related.

I consulted the common issues in the TechBrief "Upgrading to Filemaker 7 : Migration Foundation and Methodologies". It says something about the fact that they changed indexing from ASCII to Unicode. I think it might be the reason why it's not working, but does someone has an idea on how I could make it work ?

[freelancer]

For your information, I've tried the relationship without my script and it works. I just wanted to let you know that there's no problem with the multivaluated relationship in FM7.

It's got to be something with my script. I'll figure it out!

Thanks anyways!