Results 1 to 5 of 5
  1. #1
    KarenAbel is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2020
    Posts
    2

    How to preserve 'no duplicates' for a table whilst adding multiple entries for a related table

    Hello. I'm new to Access and would appreciate some help. I'm creating a database to manage the evolving requests for new subscription resources at an academic library. I have a table for resources (where a resource may only be listed once so that cost information etc isn't duplicated). And I have a table for requests. There is a one to many relationship between resources and requests as one resource may be requested multiple times. I have set up a form so that staff can enter requests as they arrive. There is a combo box in the form to pick out the title of the resource (using a lookup to the resource table) as it may have been requested before. However, because the resources table is set up to disallow duplicates, the form won't let a repeat request be made for the same resource. What I want to achieve is a record of repeat requests without the resources table having to accept duplicates. So, I want the form to clock the request and its relationship to the resource but not to re-add the title to the resources table. Can anyone help with this?

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Create a form bound to the resources table. This will be your "Main" form.
    Open the form in design mode and use the wizard to add a subform control bound to the requests table.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    KarenAbel is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2020
    Posts
    2
    Many thanks for your quick and helpful reply.

  4. #4
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2016
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Can you post a copy of your table(s) design? I think the tutorials from RogersAccessLibrary mentioned in the Database Planning and Design link in my signature would be helpful to you. It may also be helpful to you and readers if you described your proposed application ("business processes") in simple terms, plain English.
    Good luck with your project.
    Last edited by orange; 05-30-2020 at 05:13 AM. Reason: spelling

  5. #5
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Quote Originally Posted by KarenAbel View Post
    Many thanks for your quick and helpful reply.
    You're welcome
    Post back if you need more help.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

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

Similar Threads

  1. Replies: 4
    Last Post: 11-20-2015, 10:57 AM
  2. Adding Multiple Entries To 1 Table
    By sivega in forum Forms
    Replies: 2
    Last Post: 05-29-2013, 12:04 PM
  3. Replies: 11
    Last Post: 04-22-2013, 06:13 AM
  4. Replies: 7
    Last Post: 04-25-2012, 06:25 PM
  5. Replies: 14
    Last Post: 03-01-2012, 02:39 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