R
RCR
My database consists of several tables/forms, with certain fields common to
all all tables. In order to look at data from all tables, I use append
queries to transfer these common fields from all tables to a new table.
At the moment, if I want to look at a record in more detail, I look at the
record Id which tells me which table it came from, then click a button (1 for
each table), which takes me to the relevent table and record.
Is there a way that I can double click on a record, to open up the relevent
table and take me to the record, without having to select a button to press.
all all tables. In order to look at data from all tables, I use append
queries to transfer these common fields from all tables to a new table.
At the moment, if I want to look at a record in more detail, I look at the
record Id which tells me which table it came from, then click a button (1 for
each table), which takes me to the relevent table and record.
Is there a way that I can double click on a record, to open up the relevent
table and take me to the record, without having to select a button to press.