Brett, thanks for your reply. I found a way it, but now I have a report problem.
What I did was to create a text box and tell the code to give me only "Date(now)" and calculate order totals in the main form. In the payments subform I then calculated that value * tax for my payment total. It works except that now I can't figure out how to get the report to only give me information for the current order. I did this before I saw your post so I have not tried the new table. Carlos since all payment inputs will be done as soon as the order info is entered.If I remember correctly my customer does want to see all the history for each customer --- In [email protected], Brett Collings <[EMAIL PROTECTED]> wrote: > > Hi Carlos, > > Maybe you need yet another table. You have certainly shown your > understanding of a good structure and using relationships well so I > think just one more step is all you need. > > Generally, we would split your Orders into two components rather than > just one. Because the Order has many order items, you can have > tblOrder(OrderID) which is a table of each instance of an order and then > you also have tblOrderDetail(OrdDetID) which uses the the foreign key > OrderID from tblOrders to limit the items you see for the current > order. Then of course you can total them and print them out without > having to filter out the old items > > I have assumed that you really don't want to have the details of all the > old transactions on your orders subform which is why this extra table > will work so well for you. > > Of course you then create an extra subform "sfmOrdDetail" to be a > subform of "sfmOrder" (linked by OrderID) which is itself a subform of > frmCustomer (linked by CustID). You will still be able to use the > navigation buttons to look back at all that customer's old orders and > the items within each of those orders. > > I hope I have explained that clearly? I can certainly go into more > detail if you wish. > > Brett > > > > Carlos wrote: > > > Tables: > > CustomerInfo > > OrderInfo > > Model (feeds model number into OrderInfo Model as lookup) > > Payment > > > > Relationship is CustomerInfo - CustomerID to OrderInfo - CustomerID) > > one to one. OrderInfo customerID comes the CustomerInfo data. > > > > Forms > > CustomerInfo with OrderInfo subform > > Payments > > All linked by CustomerID > > > > Currently when I enter an order for a customer I enter the information > > in the orderinfo subform. For each new line item for that order I get > > a new order ID number. In the same subform (orderinfo) I also have > > all previous order information for that unique customer. > > > > So if customer "Tom" customerID = 7) on 7/8/06 orders > > A0100 qty 2 orderID 15, > > A0200 qty 5 orderID 16, and > > A0300 qty 10 orderID 17. > > > > On my subform I now have all of "Tom's" previous order history plus > > the items ordered on 7/8/06. > > > > How do I generate payment totals for only the items entered on 7/8/06 > > for CustomerID 7 which is Tom. > > > > I want to say away from popup windows to enter my order info. > > > > My customer has been using the order entry db that is preloaded with > > Access and hates all the popups. So that is really not an option. > > > > > > > -- > Brett Collings > Strengthening Families Administrator > D2D 46422 > DDI (04) 916 3422 > > > ------------------------------- > This email message and any attachment(s) is intended only for the > person(s) or entity(entities) to whom it is addressed. The > information it contains may be classified as IN CONFIDENCE and may be > legally privileged. If you are not the intended recipient any use, > disclosure or copying of the message or attachment(s) is strictly > prohibited. If you have received this message in error please > notify us immediately and destroy it and any attachment(s). > Thank you. The Ministry of Social Development accepts no > responsibility for changes made to this message or to any > attachment(s) after transmission from the Ministry. > ------------------------------- > > > > [Non-text portions of this message have been removed] > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
