can i base a report on two tables

Yes, you can. You need to join the tables together. Depending on what data you want to see on the report, you can do a RIGHT, LEFT or INNER join (you can lookup joins in HELP to determine what type of join you want to do).

Good luck!