Access Table Primary Key

Hi Andy,

Thank you for your question and welcome to the forum.

I believe it will have an impact as all the queries and forms are based on the data in the tables.

What you could do is create a make table action query to create a new table with the current set of records before you change the Supplier from 0 to 1. This will allow you to keep the historic data in a separate table.

I see from the information that you are coming on the Intermediate course and you will learn that function then.

If you create a query in Design View and go to the Query Tools menu and Design Tab, you will see the Make Table Action query option.

Here is a link to an example:

http://www.youtube.com/watch?v=bI_3iWHBL1Y

I hope this helps.

Regards

Simon