OK, problem solved. Here's the code from your first post that you say blows up because those bo_xxx columns aren't in the table:

dr["bo_bldg"] = Session["bldg"];
dr["bo_reqnr"] = Session["reqnr"];
dr["bo_maj"] = Session["major"];
dr["bo_smaj"] = Session["subMajor"];
dr["bo_min"] = this.txtic_min.Text;

Now, here's the relevant part of your Select statement:

SELECT bp_rqac.*, 
       bo_bldg as building,   
       bo_reqnr as requisitioner, 
       bo_maj as majorCategory, 
       bo_smaj as subMajorCategory, 
       bo_min as minorCategory, 
       bo_item as item,  
... etc.etc.

Anything obvious jump out at you? <s> There is no "bo_bldg" column in your table because you're calling it "building".

~~Bonnie


>I don't actually pull from 2 tables separately, I do use the join....here is the method which I access from the BP_RQAC_BO business object.
>
>public DataSet GetRecordsForItemWithOrderQty(string building, string requisitioner, string majorCategory,string subMajorCategory, string minorCategory, string item)
>{
> // Added bldg, reqnr, maj cat to dataset... 04/07/04 (ps)
> return this.GetDataSet("SELECT bp_rqac.*, bo_bldg as building, bo_reqnr as requisitioner, bo_maj as majorCategory, bo_smaj as subMajorCategory, bo_min as minorCategory, bo_item as item, bp_bidod.bo_invqty, bp_bidod.bo_invunit, bp_bidod.bo_delqty, bp_bidod.bo_delunit FROM FINSYS!bp_rqac LEFT OUTER JOIN FINSYS!bp_bidod ON ra_maj = bo_maj AND ra_reqnr = bo_reqnr WHERE ra_reqnr = '" + requisitioner + "' AND ra_maj = '" + majorCategory + "' AND ra_acct = bo_acct AND bo_bldg = '"+ building + "' AND bo_item = '" + item +"' ORDER BY ra_acct");
>}
>
>**Disregard the syntax if you catch extra (+) or ("") as I just copied & pasted it in here. This select statement gets me the correct data records.
>
>If you need anymore information that will help, please just let me know. Thanks!
>