Linking to another table with subtables

[Guest]

I want to link to a table in another database that has subtables. When I try
to link to the table, I get the main data but lose the subtables. Is there a
solution to this?

 

[Jeff Boyce]

What is your definition of "subtables"? Access has tables (and queries and
forms and ...), but I don't recall seeing "subtables".

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

For example you have a table with several rows of records with various
information. Next to each record is a "+" that you click on to open a
smaller table with more information pertaining to the record.

 

[Jeff Boyce]

It sounds like you're describing a "child" table (the one in which you are
seeing the "+" would be considered a "parent" table). Another way to
describe it is that you seem to be working with tables that are related
"one-to-many" (the "one"/parent and the "many"/child).

Since they are all tables, you could open a new Access database (empty),
then link to as many of the tables (including the "child" tables) in the
other database as you wish to.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

I did exactly that, trying to both link and then import but the only
information included in the new table was the parent info and the child data
was lost.

 

[Jeff Boyce]

Josh

In a standard Microsoft Access application design, all of the tables (i.e.,
data) are located on a server, and a copy of the forms/queries/reports/code
is placed on each desktop using the application. The "front-end" on the
desktops is linked to tables in the "back-end" (on the server).

Can you describe the configuration you are working with? I don't understand
what "lost" means. Are you saying that after you try to link from one
Access database to tables in another, the tables disappear from the other?

Or are you saying that you are linking ONLY to the "parent"/one table and
then can't seen the "child" tables. If you don't link to them (the "child"
tables), you won't see them.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

It is correst that I'm not linking to the subform but I'm not given the
option. For example, the parent is called "NCR" and the child "NCR
Subtable". When I go to the original database that has these tables, the
list of tables includes NCR but not NCR Subtable, however when I open NCR the
child info is in there as well. Now when I open my other database and attemp
to link to the table I can link to "NCR" but "NCR Subtable" is not on the
list. I hope this better explains my problem. Sorry about the confusion.

 

[Jeff Boyce]

Josh

'fraid you've confused me further...

It is correst that I'm not linking to the subform

I thought you were talking about tables. Did you mean you have not set a
link to the "child" table? If you want to see it, you MUST link to it.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Sorry, I did mean to say child table. When I go to link to this Child table
it is not on the list of tables. For example, the parent is called "NCR" and
the child "NCR
Subtable". When I go to the original database that has these tables, the
list of tables includes NCR but not NCR Subtable, however when I open NCR the
child info is in there as well. Now when I open my other database and attemp
to link to the table I can link to "NCR" but "NCR Subtable" is not on the
list. The "child" table seems to be hidden or maybe I'm just not looking in
the right place. Sorry about the confusion.

 

[Jeff Boyce]

Josh

You may have just solved your issue. You can open the original database and
see the parent, but not the child. As you point out, maybe the child table
is hidden. Have you clicked on the Windows | Unhide menu choice?

Regards

Jeff Boyce
Microsoft Office/Access MVP