Question Adding data after using a query

[newaccesslearner]

I am creating a database to track donations and donors. So far I have created the following tables:
1. Donors
1.1. DonorID (primary key)
1.2. LastName
1.3. FirstName
1.4. StreetNumber
1.5. StreetName
1.6. City
1.7. Province
1.8. PostalCode
1.9. HomePhone
1.10. CellPhone
1.11. Email
2. Donations
2.1. DonationsID (primary key)
2.2. DonationDate
2.3. DonationAmount
2.4. DonationReceiptNumber
2.5. DonorID (foreign key)
2.6. ProjectID (foreign key)
2.7. PaymentMethodID (foreign key)
3. Projects
3.1. ProjectID (primary key)
3.2. ProjectName
4. Payment methods
4.1. PaymentMethodID (primary key)
4.2. PaymentMethod
Relationships have been established with primary key on the one side and foreign keys on the many side.
I have created a query where a home phone number is entered followed by entering the first name. It brings up the donor information for a donor who exists on the database.
Here I want help from the forum.
If the donor existed then a form to enter donation should open up.
If the donor does not exist on the database then a message saying the “This donor does not exist on the database. Do you want to Add?”. If the user enters Y then the form to add donor should open up.
It is possible that a home phone number exists but the first name may not exist. (Home phone number is for the family and a family member might not exist as he/she did not donate before). In this case the form should allow to enter the donor’s other information and then the donation.
Any help is highly appreciated.

 

[plog]

Here's what I would do form-wise:

I would have a form for Donor's, this will display all the data from Donors table and allow additions and edits to all the data in Donors. At the bottom will be a sub-form listing all their donations. This sub-form will be based on the Donations table and allow the user to add and edit all that donor's donations.

Next I would create a form to search all the donors. That form would have an unbound input box at the top where a user could type in part of a name. Below that would be a continous sub-form that would show just donors matching the input criteria. Every record of the sub-form would have a button on the left to open the Donors Form I mentioned before to that specific donor's data, next to that it would have the donor's full name listed and then finally it would list the phone number associated with that donor. Beneath that would be a button that says 'Add New Donor' and opens the Donor form to a blank new record.

So this is how it would work. User opens the Search Form, types in part of a name, all matches are displayed in the sub-form, they can either click the button besides the exact donor they want (multiple may be listed) or they can use the bottom button if they one they want do not appear.

 

[newaccesslearner]

Thank you plog