Results 1 to 2 of 2
  1. #1
    coldsmokeski is offline Novice
    Windows 8 Access 2013 64bit
    Join Date
    May 2018
    Posts
    2

    Insert, update and delete records from form to table(s) - application help

    Hoping for some advice and/or direction. Trying to build what I think should be a relatively easy application in Access. It is essentially a questionnaire for evaluating file documentation.



    I have the database structure defined to where I think it should be but don't have the depth to figure out how to insert, update and delete the table data using forms.

    Here is the database structure:

    Click image for larger version. 

Name:	FileReviewRelationships'.JPG 
Views:	13 
Size:	54.7 KB 
ID:	34080

    Here is what I envision the entry form looking like:

    Click image for larger version. 

Name:	FileReviewEntry.JPG 
Views:	13 
Size:	43.0 KB 
ID:	34082


    The data from the fields in the top, purple circle would be written to tblReviewData. This is simple enough as the form and necessary buttons can be added through standard wizard functionality.

    The data from the fields in the bottom, red circle would be written to tblReviewResponses with the data relating back to tblReviewData joined on ReviewDataID. tbleReviewResponses is essentially the collection of questions (QuestionIDs) from tblQuestions that have been displayed to the user and have received a response (ResponseValID) from tblResponseVal that then relate back to the tblReviewData on ReviewDataID. Ideally the questions would be conditionally displayed based on the 'ContractAmount' value (I don't think this will be that difficult).

    I am having fundamental issues in determining how to add records to tblReviewResponses.

    Does anyone have any examples of this type of thing in a sample database? Any advice or resources that might help me out would be greatly appreciated.

    Thanks!
    Attached Thumbnails Attached Thumbnails FileReviewEntry.JPG  

  2. #2
    coldsmokeski is offline Novice
    Windows 8 Access 2013 64bit
    Join Date
    May 2018
    Posts
    2
    I think I put this in the wrong forum. Could you move to Access Forums/Access please?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 06-10-2015, 10:06 AM
  2. Update, delete and insert queries between two tables
    By ideasfactory in forum Queries
    Replies: 5
    Last Post: 05-19-2015, 08:25 AM
  3. Update, Delete and Insert Help
    By cshannon in forum Access
    Replies: 1
    Last Post: 02-10-2014, 10:59 PM
  4. Replies: 2
    Last Post: 12-20-2011, 07:33 AM
  5. update vs. delete / insert
    By markjkubicki in forum Programming
    Replies: 1
    Last Post: 09-23-2010, 07:44 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums