If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
No Duplicate Names
I am seeking to create a table of names in a manor that will ensure there are
no duplicate names from a particular address. For instance it would allow for separate records for John Smith at 123 Main Street and John Smith at 456 Broadway, but not two records for John Smith from the same address. I've tried creating a primary key using fnme, lnme, and add, this does ensure the unique records but does not allow enforcement of referential integrity. P.S. Can someone suggest a good book that might be able to turn a relative simpleton of databases into a well versed access user. Thank you all in advance for your advice. |
#2
|
|||
|
|||
Jimmi
Are you concerned with the possibility that John Smith has a son named John, living at the same address? Good luck Jeff Boyce Access MVP "Jimmi B" wrote in message ... I am seeking to create a table of names in a manor that will ensure there are no duplicate names from a particular address. For instance it would allow for separate records for John Smith at 123 Main Street and John Smith at 456 Broadway, but not two records for John Smith from the same address. I've tried creating a primary key using fnme, lnme, and add, this does ensure the unique records but does not allow enforcement of referential integrity. P.S. Can someone suggest a good book that might be able to turn a relative simpleton of databases into a well versed access user. Thank you all in advance for your advice. |
#3
|
|||
|
|||
you might try using an Autonumber as the primary key in your table, and
simply creating a unique index using the fname, lname, add fields. that will ensure "unique-ness", will at the same time providing you with a single-field primary key to use as a foreign key in related tables. suggest you give some thought to Jeff Boyce's question, or you may find yourself with data that you're unable to enter into your table, at some point. as for books, depends on your current skill level. for newbies, i often recommend the "Microsoft Access version Bible" by Prague and Irwin. "Building Microsoft Access Applications" by John Viescas has been often recommended by expert developers here in the newsgroups. i haven't seen the book myself but i trust the judgment of those who have, so i'm confident it's a valuable tool - i'm just not sure what skill level it's aimed at. hth "Jimmi B" wrote in message ... I am seeking to create a table of names in a manor that will ensure there are no duplicate names from a particular address. For instance it would allow for separate records for John Smith at 123 Main Street and John Smith at 456 Broadway, but not two records for John Smith from the same address. I've tried creating a primary key using fnme, lnme, and add, this does ensure the unique records but does not allow enforcement of referential integrity. P.S. Can someone suggest a good book that might be able to turn a relative simpleton of databases into a well versed access user. Thank you all in advance for your advice. |
#4
|
|||
|
|||
"tina" wrote: you might try using an Autonumber as the primary key in your table, and simply creating a unique index using the fname, lname, add fields. that will ensure "unique-ness", will at the same time providing you with a single-field primary key to use as a foreign key in related tables. suggest you give some thought to Jeff Boyce's question, or you may find yourself with data that you're unable to enter into your table, at some point. as for books, depends on your current skill level. for newbies, i often recommend the "Microsoft Access version Bible" by Prague and Irwin. "Building Microsoft Access Applications" by John Viescas has been often recommended by expert developers here in the newsgroups. i haven't seen the book myself but i trust the judgment of those who have, so i'm confident it's a valuable tool - i'm just not sure what skill level it's aimed at. hth "Jimmi B" wrote in message ... I am seeking to create a table of names in a manor that will ensure there are no duplicate names from a particular address. For instance it would allow for separate records for John Smith at 123 Main Street and John Smith at 456 Broadway, but not two records for John Smith from the same address. I've tried creating a primary key using fnme, lnme, and add, this does ensure the unique records but does not allow enforcement of referential integrity. P.S. Can someone suggest a good book that might be able to turn a relative simpleton of databases into a well versed access user. Thank you all in advance for your advice. Thank you for the replies. To answer Jeff's question; no, what I am trying to develop is a complaint tracking system wherein a user could track complaints by complainant. My fear is that if some individuals call frequent ly they would create needless records in that table and secondly if an individual moves I would like to keep the referential integrity. Perhaps my logic is flawed in thinking that I need to assure that records are unique. Thank you for the titles, I will try the Access Bible. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Column Names in Listbox | CK | Using Forms | 5 | November 6th, 2004 02:46 PM |
Identifying and Marking Duplicate entries | Kari | General Discussion | 4 | September 7th, 2004 05:50 PM |
Finding duplicate names | Matt in AZ | General Discussion | 1 | June 14th, 2004 08:18 PM |
Question on Resolving names | Jennifer | Contacts | 1 | May 31st, 2004 07:43 PM |
need to duplicate names in a list | Barry | Setting up and Configuration | 1 | March 3rd, 2004 02:10 AM |