I am trying convert a database from a multifile FM6 to a single file FM8.

This is used in a multiuser network hosted on FM Server. (I am currently changing it off network)

I have a relationship that is not working.

On one side I have a global field that I am trying to set as the Username (as defined in preferences). In the previous version it was set via a startup script and I am trying to so again. On the other side is a calculation that results in a list of names.

I have several portals that show lists of records they work on for each person using the database.

Now the problem... I can set the global field just fine. I originally had used a set field, but now I have also tried a copy/paste and the insert username. When doing so, the relationship does not work and I get empty portals. But... if I type a person's name into the global field, everything works fine.

Does anyone know what is up?

Thanks!

Try following your Set Field step with Commit Records/Requests and/or Refresh Window with the option to "flush cached join results".

Thanks a bunch! Works like a charm.