Too many times i have come across problems that really aren’t the problem that I thought I had.
I just spent a few hours trying to debug a “Show Single Category” problem. I was cruising back and forth between a DB that had a working version and a the db that wasnt working, blah blah, you know the usual work in progress stuff… Well this isnt the first time i have seen this happen.
The designer will let you think that you are saving changes when you really aren’t. It has the ability to save only partial changes to a view or a form that you just made multiple changes to.
So if you ever feel like you are working on something that should be working but isnt. Don’t hesitate to drop back and and close all of your designer windows. Chances are good that when you re-open what you were working on you will see that all those changes you thought you were making never really took…or at least the important ones.
Hope this helps someone.