Originally Posted by
June7
You already know what you have to do. The fields must be same type. Why does one of the keys begin with a letter? Is rest of key numerals and same as the other keys? Show sample data.
Thanks for replying. The user is adimate about using their unique keys and the only way this could happen is if the datatype is text. As a rule; I dislike using a text field on all numeric fields. Further; I am torn to using autonumber as a primary key. I always have a hard time when I query and create forms and reports. The initial load of data will be done done via spreadsheet with multiple tabs. I don't know why two of the unique keys begin with a letter.
Code:
Table 1 Unique key U-1070
Table 2 Unique key 10889
Table 3 Unique key P-7955
Table 4 Unique key 15675
I'm open to suggestions.