If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Creating an Account Transaction database
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! |
#2
|
|||
|
|||
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" wrote: 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! |
#3
|
|||
|
|||
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)... "Stephen Knapp" wrote: 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" wrote: 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! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Continuing VLOOKUP Question | JimFor | General Discussion | 13 | November 3rd, 2004 12:54 PM |
creating an MDE file when the MDB file references another database | Paul James | Database Design | 2 | October 31st, 2004 09:07 PM |
Database Window Gone | DaveB | General Discussion | 2 | July 29th, 2004 12:24 AM |
reply from correct address with a twist | Johnathon Wright | General Discussion | 3 | June 22nd, 2004 06:26 AM |
Creating a Multiuser Database | Angela Charsha | Database Design | 1 | June 9th, 2004 04:13 AM |