X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Pledges Payments Banking Tables Normalization, Any Version    
post Aug 27 2019, 03:33 PM

Posts: 18
Joined: 28-May 19

laugh.gif Hi!
I'm having a hard time normalizing my DB for a NonForProfit
I made all transactions (donations, expenses, distributions...) in one table called TRANSACTIONS
now I"m trying to add PLEDGES and BANKNIG Data.
My problem is that I have a few ways to normalize it and I"m not sure which is the right way.
perhaps those with more experience could help me out.

[for example: Should I add pledges to the same TRANSACTIONS table and add a field TRANSACTION_TYPE to be able to defer between payments and pledges, or should I make an individual table for pledges, payments and c.o.d donations and combine them in a union query? should I create a bank_transactions table and add a Bank_ID field in the TRANSACTION table or should I add an amount field in the banking table and add the amount there)
Go to the top of the page
post Aug 27 2019, 04:50 PM

Posts: 3,333
Joined: 27-February 09

I'm not sure they all belong in the same table. Can you post the table definitions for these tables?
you could use UNION ALL to show all the different things in one result set. The problem is that you can't enforce referential integrity on only part of this (well, some but not all records in a table - it's all or nothing.)
Go to the top of the page
Jeff B.
post Aug 27 2019, 05:41 PM

UtterAccess VIP
Posts: 10,305
Joined: 30-April 10
From: Pacific NorthWet

I assume you are only concerning yourself with pledges/donations of a monetary type … I've worked with non-profits that allow/encourage in-kind pledges/donations.

More info, please...


Jeff Boyce
Microsoft Access MVP (2002-2015)

Mention of hardware or software is, in no way, an endorsement thereof. The FTC of the USA made this disclaimer necessary/possible.
Go to the top of the page
post Aug 28 2019, 02:52 PM

Posts: 18
Joined: 28-May 19

DONATIONS are like QB Sales Receipt
PLEDGES are like QB Invoices
PAYMENT are like QB Receive Payments

the DONATIONS table is the most simple:
it contains: date, donor, method, account, event, amount, solicitedby, ,,, fields.
it also contains a field BankTransactionsID linked to BankTransactions - parent table

I"m not sure if i should include the PLEDGES in this table,
I"m not sure if i should include the PAYMENTS in this table,

The way to include them would be to add a field in the transactions table: TRANSACTION_TYPE
and then make a query named PAYMENTS to filter out the other records
and then make a query named PLEDGES to filter out the other records
And make a join table PLEDGES_PAYMENTS to record the payments for the pledges.
or should i make 2 or 3 seperate tables.
p.s. only money pledges in this org.
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    20th October 2019 - 12:12 PM