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

    Database design

    I am an Access newbie. I need to create a database for a bunch of cases that have payments on different days and they have the same case id.
    Can i have this in an access database? For example:

    Case Name Invoice Date Amount Case id
    Stramer v Caldwell 356112 12/11/2019 700 199221
    Stramer v Caldwell 356112 12/12/2019 110 199221


    Stramer v Caldwell 356112 08/01/2020 250 199221
    Stramer v Caldwell 356112 04/02/2020 25 199221
    Stramer v Caldwell 356112 07/03/2020 130 199221

    When I make the Case ID or the Case name a primary key Access won't allow me.
    What would be the solution to such a database? Thank you.

  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
    I suggest that you read a little on database design.

    From what you've told us, I think you would need at least two tables with a one to many relationship.
    First would store details of cases (CaseIDpk and Case Names). This would be the "one" part.
    Second would store details of Payments (PaymentDate, CaseIDfk, AmountPaid)
    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
    tyler89 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2020
    Posts
    2
    Thank you Bob, much appreciated. Do you know any good posts or tutorials on database design?

  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
    See the Database Planning and Design link in my signature for articles/tutorials/videos.
    I recommend the tutorials from RogersAccessLibrary mentioned in the link. Work through 1 or 2 tutorials and you will learn a process that can be used with any data base.
    Good luck.

  5. #5
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    You might work through the tutorials at RogersAccessLibrary.com
    Also see Access Basics By Crystal

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

Similar Threads

  1. Replies: 9
    Last Post: 06-23-2018, 10:25 PM
  2. Replies: 18
    Last Post: 12-04-2017, 05:25 PM
  3. Replies: 3
    Last Post: 01-13-2017, 03:52 PM
  4. Replies: 2
    Last Post: 01-28-2013, 04:42 PM
  5. Database Design for Specification Database
    By khwaja in forum Database Design
    Replies: 2
    Last Post: 11-24-2011, 03:58 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