I have a database that I'm setting up via Access. We want the primary key to be a last name+#.
Is there any easier way then copying and pasting groups of last names and typing the numbers in manually?
Thank you in advance.
I have a database that I'm setting up via Access. We want the primary key to be a last name+#.
Is there any easier way then copying and pasting groups of last names and typing the numbers in manually?
Thank you in advance.
I would set the primary key to be Surname & Initials rather than number. Would this be possible for you?
What is wrong with just using an AutoNumber as the PrimaryKey? People have been known to change their LastName.
Because we have enough names that we would have repeats that wouldn't work with Access. We'd like to be able to combine two columns that has a series of numbers and last names. I've been looking through a bunch of information on how to combine data from two columns. I have a feeling that I'm going to have to write a macro in VBA.
I just don't know where to start with writing the code for one table. If any of you out there could help me out on that, that would be great... because I'm at a loss.
In this case, it's a moot point. This is for a cemetery's database. And we didn't want to use Auto Number because, if we're doing a quick search it's easier to use a combination of last names and numbers then just numbers.
You can search on any field you want. You can also index on any field you want. Neither has anything to do with a PrimaryKey.