CODEWITHSUNDEEP
ms-access
Amilcar Rocha
Amilcar Rocha

Reputation: 21

Can't add records after the 8th ms-access related table

I am sorry, to all of you who have answered, for my bad English and lack of information.

I am working on a project that needs to include the entire structure of the UDC - Universal Decimal Classification which is a bibliographic classification system.

I need 10 or 11 related tables.

Tbl1 relates (one-to-many) Tbl2; Tbl2 relates (one-to-many) Tbl3; Tbl3 relates (one-to-many) Tbl4;Tbl4 relates (one-to-many) Tbl5; Tbl5 relates (one-to-many) Tbl6; (...) to the last table.

I've done the relations without difficulties ... the problem arises in filling the tables, in concrete, after the eighth table. I can not find the "+" sign, in table mode, to create new record in the ninth table.

Screenshot:

here is a print screen of my problem

Upvotes: 1

Views: 53

Answers (1)

Andre
Andre

Reputation: 27644

Actually I think this is exactly the issue:

Access 2016 specifications -> Form and Report

Number of levels of nested forms or reports   7

You have the base table Table1, and then 7 levels of nested sub-tables (Table2 .. Table8), and then Access doesn't provide further nesting.

Editing data directly in so deeply nested table would be impractical anyways. You'll need forms to navigate the levels and parents, and enter data. Breadcrumbs navigation is probably a good idea.

Actually, I would use a single main form where you switch the recordsource depending on the current level.

Note: for ad-hoc data entry at the deepest levels, just open e.g. Table7 directly, and enter the foreign keys to Table6 manually.

Upvotes: 1

Related Questions