I've succesfully displayed data from my legacy database using a sproc to implement all the business rules behind the query. Some of the data, though, is based on subqueries and is not in the base table displayed in the default list of tables. For example, order totals, address logic, etc. When I go to edit or display details from a selected record, I receive Invalid Column name errors on the generated fields.
Any quick solutions or pointers to examples on how to handle this scenario?
View Complete Post