E
Evi
Sorry about this. It's going to be complicated!
A friend runs a small charitable organisation which gets funding from
various sources. I've made her a database for her expenses which she has
used for 2 years.
Amongst other fields, she has a link to a table of Items on which money has
been spent.
Now she would like to add the facility to record her income. Normally this
would be another field in the database but there are complications.
She gets income from different charity funds so I need
a Funders Table
But the funders often give funds for a specific purpose. So the European
Lottery might give say £50 *towards* a new computer and £400 to pay for an
admin assistant for 4 months.
Another funder might give money for similar or different purposes while
another might just hand over a lump sum to be administered as necessary.
So I need a FundersItems table with links to the Items Table and links to
Funders Table
Should I link this FundersItems table to the Income Expenses table instead
of the Funders table?
She needs to show that she has spent amounts allocated for a specific
purpose on that item so there has to be some kind of link to my
Income/Expenses table. Or should there be? I'm just undecided what to link
to it.
Or should I use a completely different table to enter income and then mess
around with union queries or something to put the 2 tables together (sounds
really messy to me)
What do you think?
Evi
A friend runs a small charitable organisation which gets funding from
various sources. I've made her a database for her expenses which she has
used for 2 years.
Amongst other fields, she has a link to a table of Items on which money has
been spent.
Now she would like to add the facility to record her income. Normally this
would be another field in the database but there are complications.
She gets income from different charity funds so I need
a Funders Table
But the funders often give funds for a specific purpose. So the European
Lottery might give say £50 *towards* a new computer and £400 to pay for an
admin assistant for 4 months.
Another funder might give money for similar or different purposes while
another might just hand over a lump sum to be administered as necessary.
So I need a FundersItems table with links to the Items Table and links to
Funders Table
Should I link this FundersItems table to the Income Expenses table instead
of the Funders table?
She needs to show that she has spent amounts allocated for a specific
purpose on that item so there has to be some kind of link to my
Income/Expenses table. Or should there be? I'm just undecided what to link
to it.
Or should I use a completely different table to enter income and then mess
around with union queries or something to put the 2 tables together (sounds
really messy to me)
What do you think?
Evi