Setting up validation for a forein key where primary key is an autonumber
Novice
Windows 7 64bit 
Access 2010 64bit
Setting up validation for a forein key where primary key is an autonumber
How would I set up the validation for a foreing key field when the forein key is a Primary Key as an auto number in another table? Or do I not have to set up a validation?
Designer (DesNum, LastName, FirstName) .... the DesNum is set as Autofill Number without repeats so every designer has their own code.
Collection (Collection, DesNum, Description)
Any help would be greatly appreciated.
Who is John Galt?
Windows XP Access 2007
I would use a combo box with limit to list set to yes.
Novice
Windows 7 64bit Access 2010 64bit
Thnk you very much Paul. I was wondering if that is the way I should go with it or not. I will do that.
Cheers,
Laura
Who is John Galt?
Windows XP Access 2007
Happy to help Laura, and welcome to the site by the way!
Novice
Windows 7 64bit Access 2010 64bit
Thank you Paul. I look forward to learning much more and getting to know everyone on here.
Using AutoNumber primary key on sorted column
Sequential autonumber primary key
Is it mandatory primary key should be Autonumber?
Posting Permissions
Reply With Quote