Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
View Designer Problems
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?
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement