Brett, lets look at your idea. In more detail.
On the new form that I would create (tblorder) what would my data be. Would I have what I now have in my (tblorderInfo)? What would I change on my (orderInfo). What is the foreign key?? As for my customer seeing all the history my preference for that is to use a tab form. Thanks Carlos --- In [email protected], Brett Collings <[EMAIL PROTECTED]> wrote: > > 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 > > <brett.collings012@> 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 --------------------~--> Something is new at Yahoo! Groups. Check out the enhanced email design. http://us.click.yahoo.com/SISQkA/gOaOAA/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/
