General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
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?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only