Creating an Account Transaction database

[spacerocket]

I have a transaction database which contains individual tables for Supplier,
Purchaser, Bank, etc. User can add/edit information for these tables in their
respective forms. All the tables are linked to a table called
Transaction_Records (TR), which also contain a form for user to enter the
accounts transaction for day.

In the form TR, there are combo boxes of Supplier, Purchaser, Bank, etc, so
that user can select which company the transaction is for, the payment method
and amount of payment. Is this the correct way of doing it?

Also, I would like to differentiate between Income and Expense in the form
TR. Should I use buttons that allow user to select the type of transaction,
or should I use tabs? How do I design the table to allow for such input, and
how should I design the report?

Please advise, thanks!

 

[Stephen Knapp]

I scan old newsgroup postings that do not have responses, trying to
determine why no one bothered to react to your initial inquiry, dated
11/17/2004, titled "Creating an Account Transaction database".
Your posting might have been bypassed for one or more of the following
reasons: (a) it is too vague, (b) it requires somewhat more than a simple,
direct response, (c) you are looking for someone to devise a total solution
to your problem, (d) your question will require extensive research, or (e)
you are pushing the envelope of the general, technical knowledge of those who
view the Newsgroup's postings.
If your problem hasn't yet been resolved, you can try posting it again
with new phrasing and one of us will take a fresh look at it. On your
original posting, you should click the YES or NO buttons to close out that
entry on the system.

Steve in Ohio

 

[spacerocket]

Hello,

Thanks for replying. Actually I already have my database ready and am
currently doing testing. I posted this to get some expert opinion because I
would like to find out if there is anything that I might have missed out (eg.
something that I shouldn't do or some keywords that I shouldn't use), just to
make sure that there won't be any problem with the db after using it for a
while (eg. a bug)...