Link Tables and Table Values in Access

[jainson]

Hi,

I have a database for accounts and I have a particular format which is produced by a query giving me only 50 rows which are mainly sums of a few rows above it. What I want to do is to be able to click on a field or a record for any of that 50 row to be able to open up a table consisting of records or rows that sum up to that value?

I hope I am making sense here. Basically is it possible to have a table linked to a record in another table that can pull out the constitutents of that value?

Thanks!