Value lists based on relationships have stopped working!

[gillian]

Recently upgraded from version 11 FMP to v12 - all went well apart from the fact that all value lists based upon a relationship have stopped functioning. Standard value lists are fine. This happens across the whole system and I am baffled by this. If I add a portal to the layout showing the related records they appear just fine, however I can no long get them to appear from a drop down menu.

An example is that I have a job table, a company is associated via a CompanyID, there is another table of contacts that are linked companyID to companyID in the contacts table and in the job table there is a relationship from the companyID(jobs) to companyID in the contacts table, before the upgrade the list would display a list of contacts belonging to that company so that I could add a specific contact to the job record. When this is first used it works ok, then this list becomes static no matter what the company id it remains as it was first used. Relaunching FM refreshes this.

This is running off a Windows 2008 dedicated FMS12 with 4095mb reserved for database cache.

With both Mac and PC clients, all of which experience the same issues with the drop down menus.

Has anyone else experienced this problem? All these drop down menus were working pre-upgrade. Any suggestions gratefully received.

[gillian]

One crucial thing I forgot to say, is that I use the data separation model - data in one file the interface in another; I have since been able to replicate this problem in another set of files... is this me or FMP12??

[gillian]

I have also been able to replicate this in brand new files using data separation.

See attachedTestDBs.zip

[gillian]

OK fixed this - it seems that the 'include only related values starting from' needed completing from the original table - was very simple in the end.