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

Discussion in 'Access' started by TexSki, Jun 29, 2017.

  1. TexSki

    TexSki

    Joined:
    Jun 29, 2017
    Messages:
    3
    Likes Received:
    0
    HI,
    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.
    Thanks.
     
    TexSki, Jun 29, 2017
    #1
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.