Search results

The thing is the client wants to group a bunch of order lines and invoice it. So if there are 10 Order lines in an order, she may want to invoice it as 3 invoices (6 Orderlines in 1, 4 in the next, 1 in the last etc.) I'm really confused as to what to do. :confused: I know invoicing the...

Thanks everyone. This has been helpful so far. So I'll be generating an invoice for each order line (detail) than a single invoice for the order as a whole? It's only exceptional cases where I'd have to invoice each order detail of the same order separately. That would be a lot of invoices. Is...

Okay, so I have a separate table 'Invoice' with each record corresponding to a record in the 'Orders' table?

Excuse my ignorance, but what do you mean by 'combine' the invoices?

Okay, so "Payments" would have to be a separate table. Would "Invoices" have to be another table or just a form and/or report based on the "Order" and "OrderDetails" tables?

Hi, I have a table 'Orders' and another 'OrderDetails' with a 1:M relationship. I want to know what would be the best way to handle invoicing. Usually payments are made when an order is placed. But there are cases when a payment is made after the order is fulfilled. Usulally, an Order would...

Thanks GalaxiomAtHome. Now I'm ready to move to invoicing. Not really sure how to implement that. Do I just have a field in the Orders table? Or do I need a separate table for Invoices? Would I need another table for Payments? Usually, payments are made when an order has been placed. But...

Thanks GalaxiomAtHome.

Hi, I have a form with a calculated unbound field - Tot. The control source of Total is set to = F1 + F2 where F1, F2 are bound fields on the same form. I've set the AfterUpdate event of Total to DoCmd.RunSQL ("UPDATE tbl SET Total = " & Me.Total.Value & " WHERE ID = " & Me.ID.Value & "")...

Okay, so you suggest to use autonumber for OrdrLineNumber and format it to display as 001? However I want the OrdrLineNumber to start from 1 for each Order. How would I go about doing this?

Thanks. It works fine if there is atleast 1 OrderDetail for an Order and you're trying to add a subsequent one. However when I add a new Order (mainform) and then OrderDetail the field on the subform goes 0.001, 0.002 etc. Any ideas?

Okay, so the PK for tblOrderDetails should be an autonumber? Point taken. But would you know how to store this detail in another field?

They are linked via OrderID. I need it this way for invoicing. In most cases, the order would be invoiced as whole. But I need it for exceptional cases where invoices are needed for each individual Order Detail. I think it has to be done this way. No?

No, it's on the main form

It doesn't seem to work. It comes up as #Name? on the form

No possibility of that. Max would be about 300

Hi, I have a form frmOrder and a subform sbfrmOrderDetails. The PK OrderID for tblOrders is a autonumber. I want to create a sequential ID for tblOrderDetails such that OrderDetailID would be 8888.001, 888.002 etc. for OrderID 8888 and 8889.001, 8889.002 etc. for the next OrderID. I've...

Ah, I know what I did wrong. Had set appID -> Indexed: Yes(No Duplicates) in the appAddress table. Changed it to Indexed: Yes(Duplicates OK) Thanks.

How/Why does Access decide on it's own? Attached the screenshot. Thanks....

Hi, I have a table 'User' and another 'Address'. The userID is included in the 'Address' table as a FK. I'm using Access 2002 and when I go to edit the relationship, it is automatically set as a 1:1 relationship. How do I change it to 1:M? Thanks.