Jump to content
Sign in to follow this  
susan7

Match Field is a Calculation Field

Recommended Posts

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!

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.