Results 1 to 3 of 3
  1. #1
    jjsande1492 is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    May 2018
    Posts
    38

    Adding records to one table using a form joined to another table

    Hi, everyone.

    Attached is a test database. In it, there are three tables:

    1. Ontologys - A list of categories a product can belong to. This is a linked table in my production database. I cannot alter its structure.
    2. tbl_ImageReferences - A reference number and associated required images for that reference.
    3. tbl_ImageRequirements - The list of ontologys (categories) and the reference assigned to it.

    The idea here being that for any given product category, a set of images is required for all products in that category.

    I have a datasheet form (frm_ImageRequirements) where I want to edit the ontologys and the references. In effect, I want to be able to edit tbl_ImagesReferences and tbl_ImageRequirements in one form. I need to keep it as a datasheet. What I want to achieve in this form is for the user to see all ontologys regardless of whether or not a reference is assigned to it. I want the user to be able to edit the reference number and I want the user to be able to edit the images required for that reference number. My current form does all of that. What it cannot do is add a new reference or delete reference in the tbl_ImageReferences table.



    Can I achieve what I am asking in one datasheet form?

    imagestest.accdb

    Thank you,
    jj

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    the table: tbl_ImageReferences
    you will want to key both fields:

    Reference_ID*
    Reference *

    this way you can add > 1 reference to the ontholgy,
    and it will prevent duplicate entries.

    with this you may want some forms,
    form1 the list of all ontolgys, user clicks a detail button,
    this opens form2, a single record detail form, that has a subform to see all tbl_ImageReferences for this 1 Ontolgy.

  3. #3
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Quote Originally Posted by jjsande1492 View Post
    Can I achieve what I am asking in one datasheet form?
    Probably not.
    I see at least 4 forms.....
    A form for adding basic records for Image References and a form for addingOntologys.

    Then a form for linking Ontologys to Image References and a form for linking Image References to Ontologys.
    There last 2 forms depend on how you want to view the data.


    Maybe this example will help you....
    Attached Files Attached Files

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

Similar Threads

  1. Adding Records from Unbound Form to Database Table
    By lzook88 in forum Programming
    Replies: 19
    Last Post: 09-13-2015, 05:18 PM
  2. Adding Records to a Table From Form Question
    By McArthurGDM in forum Access
    Replies: 1
    Last Post: 03-11-2015, 07:35 PM
  3. Replies: 4
    Last Post: 12-30-2013, 01:49 PM
  4. Adding records to a table from a form
    By paulofranchico in forum Forms
    Replies: 1
    Last Post: 02-07-2012, 11:30 AM
  5. Re: Adding a new record to a joined table
    By Mcdodre in forum Access
    Replies: 4
    Last Post: 06-30-2010, 12:07 PM

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