design question2

[rodchar]

hey all,

how do receipts tie in to the payments table and invoice table? does it
usually have it's own table? if so, how does it relate to the other tables?

thanks,
rodchar

 

[Jeff Boyce]

Those of us just joining in don't have much of a clue...

Tables reflect the entities about which you're keeping facts in a
well-normalized data design. What're the entities and relationships about
which you are collecting data?

Jeff Boyce
<Access MVP>

 

[rodchar]

i'm just trying to figure out where some fields go when designing my database
system. like if i wanted to keep track of receipts for a payment what table
would that be stored in.

i'm just speaking high-level basic foundation tables for a small financial
system. just to try to understand how tables would be broken down.

other fields i'm curious about are past due amount, late fees.

i'm just trying to understand better where some things would go.

thanks,
rodchar

 

[Jeff Boyce]

You may be a step or two ahead of yourself. Take a look at how the
Northwind (sample) database that comes with Access is organized for ideas.

If you are trying to re-build the functionality in MS Money or Quicken or
one of the other "small financial systems", it must be a labor of love. It
will almost certainly cost you a lot more to do it yourself than buy one of
these...<g>

Regards

Jeff Boyce
<Access MVP>