Join workman_MAIN!lu_Catagory ; ON JobContact.fk_Type_id = lu_Catagory.pk_idAnybody know what would cause this?
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