I've not really used PK in anything I've done. I did wonder what it was for (this db isn't one I made). There is a subForm and a join where recordsource is
Code:
SELECT DISTINCTROW Tracks.*, *
FROM Disks RIGHT JOIN Tracks ON Disks.dNum = Tracks.iNum
ORDER BY Tracks.iNum, Tracks.tNum;
Does this indicate a PK is required ?
By "preventing doubles" do you mean duplicates? If yes could I set Indexed to Yes (No Duplicates) ? I'll try that and see if its value can change without an error.
It would be helpful to know why it did, when PK. Perhaps further compounded by being in the BE.