Link Tables and Table Values in Access

sonaljain123

Registered User.
Local time
Today, 05:51
Joined
Jul 6, 2011
Messages
68
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!
 

Users who are viewing this thread

Back
Top Bottom