I have a view called JobContact_2. If I use the view and browse it from the command window it works fine.

If I put it in the DE of a form I get a "View definiton has been changed" error when it is requeried. If I remove the following from the view it works fine:

	Join workman_MAIN!lu_Catagory  ;
	ON  JobContact.fk_Type_id = lu_Catagory.pk_id

Anybody know what would cause this?

Here is the full view code:

Create Sql View "JOBCONTACT_2" ;
	AS Select  AddressBook.Company, ;
	Iif(Empty(AddressBook.Prefix), "", Alltrim(AddressBook.Prefix) + " ") + ;
	Iif(Empty(AddressBook.FirstName), "", Alltrim(AddressBook.FirstName) + " ") + ;
	IIF(Empty(AddressBook.MiddleName), "", Alltrim(AddressBook.MiddleName) + " ") + ;
	IIF(Empty(AddressBook.LastName), "", Alltrim(AddressBook.LastName) + " ") + ;
	IIF(Empty(AddressBook.Suffix), "", Alltrim(AddressBook.Suffix)) As ConName, ;
	lu_Catagory.cDesc, JobContact.* ;
	FROM  workman_MAIN!JobContact  ;
	LEFT Outer Join workman_MAIN!AddressBook  ;
	ON  JobContact.fk_ab_id = AddressBook.ab_id  ;
	Join workman_MAIN!lu_Catagory  ;
	ON  JobContact.fk_Type_id = lu_Catagory.pk_id  ;
	WHERE JobContact.fk_job_id = ?Thisform.ncurid  ;
	ORDER By Company