How do I set up a ledger database for 200+?

[geigersc]

Currently we use Filemaker Pro 6. This does not serve our needs to the
fullest, however we are unsure how to set up a ledger templet for the 200
people to track these individual accounts. If at all possible, we would like
to link it to their personal information accounts we currently have in
access. It will also need to print these ledgers, so we can give each person
their transaction history, and monies owed. Does anyone know how to do such
a complex proccess? (at least complex to us).

 

[John W. Vinson]

Currently we use Filemaker Pro 6. This does not serve our needs to the
fullest, however we are unsure how to set up a ledger templet for the 200
people to track these individual accounts. If at all possible, we would like
to link it to their personal information accounts we currently have in
access. It will also need to print these ledgers, so we can give each person
their transaction history, and monies owed. Does anyone know how to do such
a complex proccess? (at least complex to us).

Are you talking about doing this in FMP6 or in Access... or in a hybrid of the
two?

A 200 row table is TINY. Access can handle 200,000 records with aplomb.
Without knowing your business model it's hard to be specific, but there should
be no problem storing personal information, account information, transactions,
etc. in tables; creating queries and Forms to enter and edit the data; and
creating Reports to print it out.

On the other hand, there are plenty of good ledger/financial records databases
commercially available. Could you use Quickbooks or Peachtree Accounting or
Microsoft Money instead of reinventing the wheel?