Roi,

Could it be the parameter reference to ThisForm? I think someone mentioned in another thread that this could cause problems. Try to use a variable instead.

HTH
>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