Subforms to enter data

[novo]

Hello everyone:
I am new to the forum and Access.


As a volunteer, I am developing a database for my charity. I need a simple interface form to enter donation data.

1. First table, TAddress has only address information in it. Address ID and the address.
2. The second table, TName has the Name ID, first name, middle name, last name, second donor, home phone, cell phone, email and Address ID. This table links to the TAddress through Address ID (one in the first table, many in the second table).
3. The third table, TDonation is the donations table and has Donation ID, donation date, donation amount, Donation type ID, Donation method ID, and Name ID. It links to the second table through Name ID (one in the second table, many in the third table).
4. Fourth table, TType and fifth table, TMethod are donation type and method of payment tables.
5. For entering donations, the user types in the address partial or complete. For example if the user enters 81 Park, the system lists all the addresses beginning with 81 Park i.e. 81 Park Drive, 81 Park Lane Drive, 81 Park Wood Drive, 81 Parkdale Ave etc and the user can scroll through the list of 81 Park*
6. If the entered address is listed, the user selects that address by clicking it. The system displays all the names listed against this address and the user can scroll through them to select the name by clicking it if it exists. Now the user enters the donation against this name linked to the address.
7. In either case where the address or the name is not found, the system prompts the user to enter the address or name by popping up the appropriate form.

Any help is highly appreciated.

[June7]

Is there an issue? You describe the database and what it does but no question regarding an issue with db behavior.

[novo]

Is there an issue? You describe the database and what it does but no question regarding an issue with db behavior.

Hello June7:
I am sorry I did not make myself clear. I need to develop the form for entering donation data as mentioned in points 5,6 and 7.
Thank you
Novo

[June7]

Sounds like same topic as https://www.accessforums.net/forms/q...lem-32654.html

Look at posts 10 and 20.

[novo]

Sounds like same topic as https://www.accessforums.net/forms/q...lem-32654.html

Look at posts 10 and 20.

Thank you June7. I will try it out.
Novo