Appending tables

[msnarayanan]

For some reason or other I have to create four or five different tables but with the same fields. I.e. table 1 for receipts, table 2 for payments etc. This is to organise lookup unique for each field in all the tables.
Is it possible to append the tables to form a single table so that a report can be created with all the fields of the tables.

Your help/suggestions please.
M S Narayanan