I did a clean install of Filemaker Server 12 and this has resolved the problem.
It may have been due to an incomplete install.
I'm having exactly the same problem but reinstalling doesn't seem to have solved the issue. It isn't a problem with being able to find the other table as none valuelist entries i.e. enter the code manually and it looks up - any ideas?
No ideas im afraid, I dont know what fixed it other than doing the clean install of the server, uninstalling the previous install completely.
The table relationships all appeared to be fine, as you indicated the other table can be found, it just doesnt populate.
Do the files work OK locally?
Sry not much help
I managed to do a work around by setting up value lists in the lookup file and then setting the value list in the files I was having a problem with to 'use value list from other file'. However, the issue with cropping header graphics on layouts has meant that we have had to roll everything back to FM11 anyway as 12 is just completley unworkable. Thanks for your help though - hopefully FM will resolve this issue before we try upgrading again.
did you try re-indexing the value list?
Yes, but didn't seem to make a difference. Have had to roll back to version 11 because of the graphic cropping issue so can't try anything else now, will have to wait until the crop issue is resolved.