<div>
<div class="content wysiwyg-content">
I have 2 tables in MS Access 2010. &nbsp;<br />
<br />
The main tables rest in Database 1 and are linked into the user front end (Database 2).<br />
<br />
I have established relationships between these tables in both databases. &nbsp;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. &nbsp;The &quot;plus&quot; icon is not available to me in Database 2 when I opne the parent table - is this because the tables are linked? &nbsp;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?<br />
<br />
I hope this makes sense.<br />
<br />
Thank you<br />
Susan
</div>
</div>


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.

Thank you
Susan

Linked table Access

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.