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 Sponsor --------------------~--> See what's inside the new Yahoo! Groups email. http://us.click.yahoo.com/2pRQfA/bOaOAA/yQLSAA/q7folB/TM --------------------------------------------------------------------~-> 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/
