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.