Remarks field help

[KrakowiAneczka]

Hi!
I'm new here and I'm new to data base access.
I know a bit, but it turned out not enough to create data base for my needs.

I've got data base with land owners (names, address, REMARKS, etc.).
My primary key is Parcel_No. I've created new table called REMARKS where I want to be able to put date of comment & comment for certain Parcel. The problem I've got is that Parcel_No is primary key and it won't let me put different remark for the same Parcel (remark no 1, 2, 3 etc. with different dates but for the same Parcel).

I would appreciate any suggestions!
Thanks!

 

[Galaxiom]

Remove the PK property from the Parcel_No field in the Remarks table. It is a Foreign Key in this table.

The Remarks table probably doesn't need a primary key but you could add one as another field if you wish.

 

[KrakowiAneczka]

Thank a lot! It helped
I didn't need primary key in Remarks table at all

Cheers!