Geoff,

>I have found this is because I have a key field on a table which uses external data (data from another table).

That's a very bad thing to do. It's also bad to use a UDF in an index expression.