RE: Table Design

From: Gettingthere (Gettingthere_at_discussions.microsoft.com)
Date: 11/19/04 

Date: Thu, 18 Nov 2004 16:11:02 -0800

My i explain quickly, this database is created on the fly. Acustomer walks
in and receives an invoice preprinted by head office. the customer receives
the product and the invoice is then entered into this database, which is
purely for reconciliation. The data entry operator enters Inv number, amount
paid and how. The complication comes when we have to print Batch listing of
25 transactions for each payment type, and there is a combination batch wher
an invoice is paid by two or more methods (which can be frequent). Batch
numbers have to be unique between batches, and invoices cannot be carried
over to the next day, eg the last batch cannot include other days
transactions.

I have somewhat succefully created a database using 4 tables, one for each
transaction type and the data entry person select which form/table to enter
the data. This creates a very messy database trying to get the
reconciliation, but it makes creating batches easy. In the end I thought to
myself there must be a BETTER way of doing this!!!!

Any advise would be fatastic

Thanks

Roger

"Kevin" wrote:

> You could do it either way. Enter your invoice first, then in a different
> form enter the transaction data or have a sub form tied to the transaction
> table that is a child of the invoice data entry form. It depends on how you
> expect the process to work. Will the invoice be created at a different time
> then the transactions occuring? If so have two different forms, if you would
> be creating both at the same time, use the form/subform design.
>
> What your trying to do here is model the process that is occuring or that
> you (or your customer) want to occur.
>
> Hope that helps!
>
> Kevin
>
> "Gettingthere" wrote:
>
> > Thanks this helps alot. But if I may 1 more question.
> >
> > Would you then use in the form, the transaction form as a sub form of DATA
> > ENTRY form, where primary form is invoice?
> >
> > Thanks
> > Roger
> >
> > "Kevin" wrote:
> >
> > > I would use a normailzed table and let them choose the transaction type from
> > > a drop down list. I assume INV details is "Invoice"? If so, have two tables
> > > 1) tbl_Invoice and tbl_tansaction and tie the two together using a
> > > invoice_ID. In the transaction form, have the user choose the invoice number
> > > for each transaction. Selecting only this invoice number will mean the user
> > > only has to enter invoice detail one time, then refer to it to enter each
> > > transaction.
> > >
> > > Your report would be by invoice and could seperate each transaction and the
> > > status of that transaction etc.
> > >
> > > I hope that helps!
> > >
> > > Kevin
> > >
> > > "Gettingthere" wrote:
> > >
> > > > I have to create a database for transactions of school books. The Customer
> > > > often pays by different combination of media, eg: Pay portion by cash and pay
> > > > portion by chq. There are 4 medias, CASH, Cheque, Credit Card, Gov
> > > > Assistance.
> > > > Do i create a Non- Normalize table and include column for each or do I have
> > > > a drop down list selecting the type of payment. The second otion presents a
> > > > problem where the data entry operator may need to enter INV details two or
> > > > more times depending on how many different types of payment they use, not
> > > > posible due to restraint on time. Each type of payment needs to separated in
> > > > a list later to show all transactions of cash only, cc only etc... anything
> > > > with 2 or more types of payments need to be separated and listed on a
> > > > combination report.
> > > >
> > > > What is best practice? and How?
> > > > Thanks in advance
> > > >
> > > > Roger

Relevant Pages

  • RE: Table Design
    ... If you expect the transaction types would always be the ... > in and receives an invoice preprinted by head office. ... The data entry operator enters Inv number, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Split database continued
    ... The code for creating a one off invoice takes 12 seconds with the database ... Private Sub Create_New_Invoice_Click ... Dim Invs As DAO.Recordset ...
    (microsoft.public.access.formscoding)
  • Re: credit card reciept response
    ... transaction is submitted for processing. ... to the consumer or a POST string to a site designated by the merchant. ... Here you accept the POST data, validate it, and mark the invoice ... DO NOT send any order details back to the payment ...
    (comp.lang.php)
  • Re: tracking inventory
    ... Would you rather enter all the invoice information and expect the data is pushed to the transactional record, or would it be OK to enter the transaction details first and then generate an invoice? ... To your questions about calling up details and adjusting inventory, these should be relatively easy tasks once the broader structure of the application is defined. ... If I were keeping track of inventory, I would have a master "catalog" page that lists all the items, one per row, starting inventory counts, and a /calculated/ current inventory number. ...
    (microsoft.public.excel.misc)
  • Re: Problem with a template from the MS Office website
    ... noted and have resolve them and reposted them the updated db to our web. ... database. ... I suspect it will be ages before my Access and VBA ... and controls so that the Invoice Report ...
    (microsoft.public.access.reports)