-
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?
-
An easy way to get the SQL necessary from Access is to setup the query in access (make sure it works) and click View --> SQL to get the sql necessary to put it in your program
Tom
