Help with Query/Code for Donor Table

[iouu2]

We have two tables Donor and Donation.
Donor table consists of:
· DonorID, FirstName, LastName, Street 1, Stree2, City, State, Country, Zip and other personal information.
Donation table consists of:
· DonationID, DonorID, Date Received, Payment Method, Amoutn, ProgramID, CheckNumber
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
We are trying to create a query/code that will loop through our Donor table and look for a donors name, if that name is not found then a new random number is generated for the DonorID. If the name is found, the assigned DonorID number is inserted in the form/table.

Any advice/help is appreciated!

 

[boblarson]

Here's a thought - have a main form/subform set up with the main form consisting of the Donor table and then the donations as a subform. Then you don't have to do anything. All you have to do is to have an unbound combo to select the donor and then enter the donation information into the subform (the master/child links would be on DonorID and the form would automatically enter that into the donations table) and then to add a new Donor just navigate to a new record on the main form which you can then enter the donor information and any donation information quickly right from the same spot (in the subform).