Can I have more than one subdatasheet in one table

[annakalli]

I am trying to create one accounting program, but I have difficulties when i am trying to have data from different subdatasheets and create a new table.

For example i have data in a table for the credit invoices and data in a another table for the payments and i cant merge them to have a new one like for example creditors statements.

like the following
date description debit credit balance
1/3/10 purchases 50
1/3/10 bank payment 30
etc

[ChipR]

If you have two tables or queries with the same fields, you can create a UNION query to view them all together.