I'm using a query to add records to a number of tables. I am using a numeric field called 'Admission Number' as my primary key. My problem is that as soon as I have five records in each table any new records that I add replace the records already present.
Any help would be much appreciated.
Thank you
Jim
Any help would be much appreciated.
Thank you
Jim