Join workman_MAIN!lu_Catagory ; >> ON JobContact.fk_Type_id = lu_Catagory.pk_id>>
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