I don't understand the part of the question about keeping previous data.
A form/report has a single RecordSource. That recordSource can be a table or a query. A query can join multiple tables or queries. So, the answer is that a form/report can show data from multiple tables but it really depends on exactly what you are trying to do.