SELECT mfr_name, mfrabbrev_name FROM tblmanufacturers WHERE mfr_id =