Ask Your Question
0

Is there a possibility to create a second level in database?

asked 2014-02-20 14:55:11 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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

edit retag flag offensive close merge delete

Comments

Unfortunately, I have no idea what you are attempting to do.

Alex Thurgood gravatar imageAlex Thurgood ( 2014-12-14 19:59:14 +0100 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2015-10-08 16:17:49 +0100

LKeithJordan gravatar image

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.):
1) ID (autonum field)
2) 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.

3) household_name
4) address
5) city
6) timestamp
7) status
8) sysflag

Now let's create "tbl_donors" with the following fields:
1) id (autonum)
2) household_id
3) donor_name
4) contribution
5) timestamp
6) status
7) 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.)

edit flag offensive delete link more
0

answered 2015-10-10 03:36:39 +0100

Steve R. gravatar image

updated 2015-10-10 03:37:25 +0100

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2014-02-20 14:55:11 +0100

Seen: 175 times

Last updated: Oct 10 '15