Access 2013: Form problem in reading data tables; relationship one-to-one

Jun 29, 2017
Reaction score
Background: Collecting info regarding individual child education centres. I have broken down the data into six individual tables, with the main table having a one-to-one relationship to the other five tables and produced a continuous form that contains all the individual fields under each table name.

As a test of the databased I entered two sets of data via the form to check population of the tables - all appeared to work.

The problem I now have, and which I am stuck on, is that the collected info for the main table has been input directly into this table via Datasheet view and when I use the form to examine the data only the two test records I entred are included. If I create a new form via 'Create > Form' it can cycle through all 45 records entered including the two test sets.

I've examined the form I created but can not understand why it only sees two records.

Any help greatly appreciated.


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