Lookup value

[elbeardo77]

I have created a database in a previous version of FM7, now I have upgraded to FM9 and some things will not work anymore!

I have a field which looks up a value from another database, it is no longer working in FM9, but if I open the file in FM7 it works fine... can anyone explain this?

Thanks

[mr_vodka]

Try reindexing the field or saving a copy as compact.

[elbeardo77]

Tried this, nothing happened!

Basically what the database does is lookup a customer from another database and then when it has been selected it should insert a unique prefix (which is also listed on each customers info)

[_henry_]

Hi,

I have a field which looks up a value from another database, it is no longer working in FM9, but if I open the file in FM7 it works fine...

Are you using some kind of triggering plugins on those fields?