Andy has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Access Advanced course
Access Table Primary Key
If I set a Primary Key using 2 fields, if the information changes in one of the fields (e.g. a status of a Supplier changes from 0 to 1), will it affect Queries and Reports functions ability to collate historic information for that Supplier?
RE: 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
