No - no auto number.  The table named DonationTypeT has 4 fields: Adoption; Donation; Puchase; AppFee.  I suppose I could create a temp field with a 1,2,3,4.  Run down all the records and entering in 1 for adotpion, 2 for donation, etc..  Then delete the DonationTypeT table.  Recreate it correctly, then re-enter the respective donation type, then delete the temp table with 1,2,3,4.  Just thinking out loud.  My original thought was exporting into excel editing the field then reimporting, but this would create more a higher probability of corrupting the data.  I already have 7,000 records some of which have multiple donation activities.  Thanks

---

Reply from Alex Hedley:

When you say DonationTypeT has 4 Fields: Adoption; Donation; Puchase; AppFee do you mean Fields or Records?

Are you wanting to relate a Donation to a specific type via a Combo?