>Hi:
>I have, what seems to me a very simple Local View to design. I have 2 files, the Client file, and a Types file. The client file contains to foreign keys to the types file, the client type - itype_id, and the client group igroup_id which match the primary key for the types file. When I create the local, and add the Types table to the view twice and adjust the join information so that the client.itypes_id points to Types_master.itypes_id, and client.igroup_id points to Types_master_a.itypes_id everything appears ok and I can browse the result set. If I save the view, and try to modify it I get an error statinging that SQL: Column igroup_id, or itypes_id (depending on which join I define second) is not found. Any suggestions?

The view designer has serious limitations when trying to create anything but the simplest types of view. Eric Moore has created a utility for opening and modifying views called e-view. You can download from the files section.