I was thinking the same as Thomas, and is not remove the LeadsourceID but to use the text value as indexed no duplicates, anyway there is not going to be another UPS, there is going to be only one so leave that field as text, is there any problem doing it this way? thank you for your valuable help, this is a great course.

---

Reply from Richard Rost:

Again, it's just considered good database design to use Autonumbers for IDs in your tables. Do you HAVE to? Nope. You can use text fields if you want. Autonumbers generally tend to cause fewer errors and save space in databases in the long run.