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. ------------------------ 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/
