>I just fired up the view designer and added two tables from the Northwind database (Categories and Employees). I added a few fields to the query, and added a filter "Categories.categoryname = 'Hello'" from the designer. Then I brought up the SQL code to try out the two-way option. I modified the line: Categories.categoryname = "Hello" to read: Categories.categoryname = "HelloThere" , then I tried to close the window, assuming it would update the view designer. Instead, I get the error "There is a duplicate table alias 'EMPLOYEES' in the FROM clause", and another "View/Query designer is unable to reload your changes. Would you like to rebuild content from designer?". Am I misunderstanding how this is supposed to work?
No, it should work as you describe. Check that you didn't introduce any syntax errors with your changes.
Tamar
Previous
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