1st child sub-table disapears when second child table added

I linked a parent and child table. The parent had an autonumber
connected to the child table field which was an ordinary number. This
worked fine when I opened each table and then the plus sign against a
record the other table appeared as a sub-table.

When I connected a second child table to the the same autonumber in
the parent table the subtables disapeared. I dont care about having
subtables as I intend am using a main form with tabbed subforms for
the child tables.

Have I broken it? Is my data connection maintained?

Cheers Graham

No you haven't broken it. Access is likely not showing a sub-datasheet
because it doesn't know which one to show. Although you could specify this
in table design, you are far, far better off changing the Sub-datasheet
property to None in table design view.
Check out http://www.allenbrowne.com/bug-09.html


--
Joan Wild
Microsoft Access MVP
"micromoth" wrote in message
oups.com...
I linked a parent and child table. The parent had an autonumber
connected to the child table field which was an ordinary number. This
worked fine when I opened each table and then the plus sign against a
record the other table appeared as a sub-table.

When I connected a second child table to the the same autonumber in
the parent table the subtables disapeared. I dont care about having
subtables as I intend am using a main form with tabbed subforms for
the child tables.

Have I broken it? Is my data connection maintained?

Cheers Graham