[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 240
  • Last Modified:

Linked table Access

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
0
Susan Stevenson
Asked:
Susan Stevenson
3 Solutions
 
Rey Obrero (Capricorn1)Commented:
you maybe referring to subDataSheet... have a read on this

http://allenbrowne.com/bug-09.html

scroll down to the topic   > Tables: SubdatasheetName,

i, for one disable this feature for reason stated in the  above link..
0
 
Dale FyeCommented:
Generally, if you have a two tables that needs to relate directly to one another, as you imply, then both tables should reside in the backend, and be linked to the front-end.
0
 
Jeffrey CoachmanCommented:
...If, on the other hand, the tables really must be in separate Databases, you can still use the Form wizard to create a Main/Subform.
*However* (obviously) you will not be able to enforce Referential Integrity.

If a true One to Many relationship is needed, then you may wish to rethink your current design and evaluate the posts by the previous experts.

JeffCoachman
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now