Reports and Forms are almost identical in the structure of the data they filter and use. So if you got it to work on your Form, then use the same criteria and code for your report.
There are lots of ways your customer can see all of the clients order history but a current order is not really the best place for that. Some of the options are ... - If you do add the extera table and the extra subform as I suggested, hthey can use the navigation buttons to scroll back through old orders - We create lots of forms from our databases and one of them would be in this case a frmCustOrdHit (Client Order History). It would have search boxes in the header so that an order item or and ordernumber could be selected, it might also have a date range selection - On the Order form you can have a button that opens the frmCustOrdHist filtered to that customer's ID number in case they need to look up previous orders while entering the current one The important thing is to present the relevant data at the time and not anything else. There's so many options and neat and tidy ways of presenting data that we alsways have the opportunity to have clean, crisp forms in front of our clients Brett Carlos wrote: > 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] <mailto:ms_access%40yahoogroups.com>, > 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] > > > > -- 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 --------------------~--> Yahoo! Groups gets a make over. See the new email design. http://us.click.yahoo.com/XISQkA/lOaOAA/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/
