I have an address data base. Right now, the first and last name are two different fields. I'm trying to make it that I can't have duplicates of the same name. I know how to do it for first or last name, but can I make it that there are no duplicates of the full name (first and last combined)?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
merging two cells
- Thread starter stumped89
- Start date
You can choose both of these fields as a primary key in the table design. This would allow duplicate fist names and duplicate last names but not a duplicate of both.
If you want to merge the two fields together run an update query on the table that merges the two fields into a new field. The downfall to this is that you won't have as much flexibility.
If you want to merge the two fields together run an update query on the table that merges the two fields into a new field. The downfall to this is that you won't have as much flexibility.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question