Newbies susan7 Posted October 28, 2004 Newbies Share Posted October 28, 2004 I have set up a calculation to generate a unique code for a contact (the first three letters of their first name and the first three letters of their second name). I want to use this field as a match field to relate to other tables but I can't have a calculation field matched with a text field, the related data isn't correct. Any help appreciated! Link to comment Share on other sites More sharing options...
Ender Posted October 28, 2004 Share Posted October 28, 2004 Susan, I strongly advise against using Names (part or whole) as relational keys. This may work at first for a small record set, but there are two major problems that you'll encounter at one point or another: 1. Eventually you will have contacts with similar or the same names. It is essential that the database knows how to keep them apart. 2. Names change over time. You would not want your relationships coming apart because some of the keys no longer match. It is much better to use an auto-entered serial number, or some other unique numbering system as the primary keys for your tables. Link to comment Share on other sites More sharing options...
Newbies susan7 Posted October 28, 2004 Author Newbies Share Posted October 28, 2004 Thanks for your advice. I am going to change the code to auto entry serial numbers. It's all fun when you're learning!! Cheers! Link to comment Share on other sites More sharing options...
Ugo DI LUCA Posted November 2, 2004 Share Posted November 2, 2004 As you read and learn, check the Article section as it has a good Unique ID technique. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7108 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now