I was having a problem with the SQL Override in a grid and found the solution, however, I don't understand why it works and hope someone can help clarify the naming convention.
I have a grid based on a table called "ProductFamily". I was getting a record count in another table called "Item" with the following:
"SELECT Count(viewaccItem.RecordID) FROM viewaccItem WHERE viewaccItem.ProductFamily_RecordID = viewaccProductFamily.RecordID"
There was an error generating the grid and I found that the problem was due to how I was referencing the ProductFamily table (the table the grid is based on). I removed "acc" from the table name and everything worked perfect (viewProductFamily instead of viewaccProductFamily).
Does anyone know why the "acc" is dropped from a table name reference when it is the table for the grid (use view[table name] instead of viewacc[table name])? The only thing I could think is that "acc" tells the system to look for an external table but if that is the case, why would you need to put "view"?
Thanks!