MS Access: Table relations via Forms

Posted on 2011-05-03
Last Modified: 2012-05-11
My table relationships are now correct. I saw the video on how to do this and I matched the connections to my tables.

However when I attempt to add a record via the form “frmInspectionsDimension” I get this error:

“You cannot add or change a record because a related record is required in table tblTools.”

In this form you are supposed to select the Tool ID which in this form only sees dimensional tools and then you enter in the Date Checked, Checked By, General Condition and Comments. You also enter any measurement checks that you might make.

If the table relationships are correct why doesn’t the form work??

Question by:James Coats
    LVL 12

    Accepted Solution

    Well the error is caused, while you need to create a ToolID in your tblInspections first.

    So from there you can pull up the information from tblTools.

    LVL 39

    Assisted Solution

    And you also should add InspectionPK from tblDimensionVerification to InspectionPK in tblInspections.

    Author Closing Comment

    by:James Coats
    Thanks guys this worked

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now