My first thought with a problem like this would be to check the SQL logs to see if there is an error.  In any case the logs will show you what SQL statement is being run so should be able to clarify what the system is actually trying to do.

Thanks, Guy.

Hmm - I revisited this after your post - I added the field back into the screen, then opened the asp page and there was NO error.  The field didn't display data, however, just the field title with a blank space underneath.

So I'm not sure what is going on - metadata will have been refreshed several times in the last few days, but otherwise I haven't changed anything with this entity.

Perhaps posting your asp page might help.  And your view definition.

There's nothing special with the asp or view.  The view returns the correct data when I execute it in SSMS.

I turned SQL logging up to max and clicked the link to open my summary asp.  My custom view doesn't show up in the log; instead the custom entity table is queried when the asp page runs, despite the fact that the screen is based on the view..  So that's why there are no data from the joined table.

There's nothing special with the asp or view.  The view returns the correct data when I execute it in SSMS.

I turned SQL logging up to max and clicked the link to open my summary asp.  My custom view doesn't show up in the log; instead the custom entity table is queried when the asp page runs, despite the fact that the screen is based on the view..  So that's why there are no data from the joined table.

Paul.  Are you using CRM.FindRecord with a view?

CRM.FindRecord("Person, vTestView", "pers_firstname like 'ABC%');

Thanks Guy - you are correct - I had omitted to add the view to the FindRecord().  I messed about with this for hours but didn't realise.  Now all good.