>Sorry for all of the questions, but I need some general guidance on how to perform multiple table queries using the MM .net framework. I know the business objects are intended to have a single tablename and primary key in the constructor of the class. I have several forms working with varied functionality with single tables. I can build a multiple table sql with the appropriate joins, just not exactly how to apply it using GetDataSet within my method of my business class.
Actually you don't have to limit yourself to one table per business object. You can have multiple tables per business object or a single table return from a complex join from multiple table. The table name property is just a alias for the returning table(s).
Stephen Lee
--------------------------------
Too much to code
Too little time
--------------------------------