example:
first level:
name Johnson
adress backstreet
city Aloha
second level:
#1 frank Johnson, contribution $20
#2 John Johnson, contribution $22
#3 Beth Johnson, contribution $15
Unfortunately, I have no idea what you are attempting to do.
Your question is not entirely clear, but it appears you are trying to track individual contributions from donors of the same household. If what I surmise is correct, the answer is yes.
There are several ways you could accomplish this task, but it appears you want to enter the household address only once, and thereby use the household as the “master table.” So, let’s set that up.
First, create a table called “tbl_households” with the following fields (These are merely suggestions. Customize to your own needs.):
- ID (autonum field)
- household_id
Note: If you use the ID field for setting relationships, the household_id field is not necessary. Otherwise, use the household_id to create a customized alphanumeric id, and keep the ID field for system use only. For our example, we’ll assume you keep the household_id field.
- household_name
- address
- city
- timestamp
- status
- sysflag
Now let’s create “tbl_donors” with the following fields:
- id (autonum)
- household_id
- donor_name
- contribution
- timestamp
- status
- sysflag
Set a relationship between tbl_households and tbl_donors on the household_id field for use as you enter data, run reports etc., so that the data integrity of the join field (“household_id”) is maintained. If you set up your input form with a subform, the parent form data source would be tbl_households and the child form data source would be tbl_donors. You could then call up a household and enter the separate contributions from each member of the selected household.
Please note that explanations of the terms “data integrity” and “join field,” and the reason for adding fields such as timestamp, status, and sysflag are outside the scope of this post.
(Please click the check next to my post if you believe my response to be the best answer to your question.)
My response is a continuation of LKeithJordan’s answer. The issue that you are faced with is “normalization”. Please review the materials located here: Base documentation. Specifically review the PDF: Base Tutorial: From Newbie to Advocate in a one, two… three.