I am designing reports using the microsoft designer in VB. I do nt have crystal reports. I have designed the user interface using the wizard. i want to link it to the database.

using access database.

plz tell me how do i link the report to the database. is there any code to be written. if yes, plz send me code snippets.

Eg:

i have transactions table and members table.

transactions - tId,memberid, issuedate,returndate,actualreturndate,fine.

members - memberid,firstname,lastname,address.

i want to display memberid,firstname,lastname,address and fine in the report. how do i do this?