I'm having a bit of trouble with an SQL join in VB5 with an Access back end. I am trying to join two tables on one field that is an autonumber, and the other field being a number. Not sure how to make this work.

Also can't figure out how to populate a DBGrid without using a data control (I'm trying to use a recordset created at run time). I can get the column headers, but not the actual records. Any suggestions?