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

M

micromoth

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
 
J

Joan Wild

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

delete parent records where child fields are blank 2
side-by-side Child & Grandchild lists 2
PLS HELP~! Simple Question: Master & Child Link without subform 3
tables to match tabbed forms 1
"Multiple Autonumber" in same table 2
Requery a sub table 1
Filtering Parent table on child records 8
How to update child records using a sub-form 1

Top