CREATE VIEW flzipmaid as sele a.* from missacct a,; family b, person c where a.zip = ?m.z_szip; AND a.fname = ?m.z_sfname; AND (a.lname = ?m.z_slname OR c.maidenname = ?m.z_slname); AND a.acctno = b.acctno; AND b.personno = c.personno; AND b.famid # 'C' group by a.acctnoI figured that either way you created the view (whether command line or view designer) it was added to the database and could therefore be modified via the view designer. Is this not the case?