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?
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.