Duplicate Value Error

[Aleathia]

I am very new to Microsoft Access (started three hours ago), and I have a problem with my database.For my assignment I need make two tables and fill them with certain information:Here you can see that until song 9 there is no problem, but when I enter the second album and song 1 it gives me this error:And for your information in table ALBUM ALBUM_no is primary key and in Tracks Tracks_no is primary key.Please help me and remember I am kind of a noob still in this.

[June7]

If TrackNo is defined as primary key then that means there cannot be duplicate values in that field. There can be only 1 of each track number. That's what primary keys are - unique values.

Your options are:

1. don't have a primary key in Tracks - a primary key is only necessary if this table has a related dependent table where the primary key value will be saved as a foreign key

2. create an Autonumber field in Tracks and define it as the primary key

3. compound primary key based on Album_No and Track_No - I advise avoiding compound keys

You need to get a full understanding of what primary and foreign keys are before proceeding.

Regardless of option chosen, probably should set the Album_No and Track_No fields as compound index to prevent duplicate pairs.