I have 2 tables in MS Access 2010.
The main tables rest in Database 1 and are linked into the user front end (Database 2).
I have established relationships between these tables in both databases. However, I want to use to be able to click on the drill down button to amend data lying in the sub table in Database 2. The "plus" icon is not available to me in Database 2 when I opne the parent table - is this because the tables are linked? Is there some other way of doing this from database 2 or can drilling down only be down within the main database (database 1) holding the data?
I hope this makes sense.