Modify the query diagram and modify the SQL code automatically, but the reverse?

[Lou_Reed]

I can create a query with tables and entries and then put in criteria. When the query is correct, I can look and see the SQL source.



However, is this reversible? By that I mean by changing the SQL code the table relationships and criteria also change?

Thanks in advance. Any help appreciated.

Respectfully,


Lou Reed

[June7]

Usually edits in SQLView will be reflected in DesignView, assuming the edits are valid syntax. However, some queries cannot be displayed in DesignView at all, ever. A UNION query is one such and can only be created and viewed in SQLView.

[Lou_Reed]

Well, I already tried it. I replaced the MeetingID line back into the SQL code for Query2 on my db. I have a Query3 that is dependent on Query2. It just would not work. I recreated Query3 and it works now.

Respectfully,

Lou Reed

[June7]

An edit in one query will not always pass through to a dependent query. I did not realize that was the actual nature of your question.