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?