Blue
White
Purple
Green
Red
Orange
Blue Light
White Light
Purple Light
Green Light
Red Light
Orange Light
When i use Add new, I can't get it to make a unique primary key.Can you tell me how to do that?? It should just take the last primary key value and add one to make it unique again.
I would recommend to use database-based methods to keep primary key values unique. For this purpose in MS Access you can use Autonumber field type.