OK, I should be able to do this, but I can't...

I need to design a report that takes a customer number from a form and returns query results from three tables. I can get a report to show data from one table by making the record source a query that pulls from one of the tables, but I need to query three tables on the same report.

I'd really appreciate somebody talking me through this one. Thanks.