Hi all,
At work, we've recently created a database to easily access all the documents required for any given order/invoice/delivery etc, where a single order may be split over several deliveries and several orders can be invoiced together. I've created a multi-table query to bring up all the related forms when an invoice number/delivery number/sales order number is given, but it's stopped updating any new orders that are being entered.
I've tried looking online for answers, but I'm very much an Access novice, especially when it comes to anything dealing with SQL. I have seen that empty fields in a record can stop it, and some of the new records don't have every field included, largely because the original database had a much larger scope than what it's being used for. Is there anyway to get it updating again?
Here's the SQL code for the query that I have:
Code:
SELECT tblCustomers.CleanName, tblDeliveries.DeliveryNo, tblDeliveries.PickList, tblDeliveries.CoC, tblDeliveries.DeliveryNote, tblInvoice.Invoice, tblInvoice.InvoiceNo, tblSalesOrderAcks.SalesOrderAckNo, tblSalesOrderAcks.SalesOrderAck, tblSalesOrderAcks.PurchaseOrder, tblDeliveries.[Airway bill/Bill of Lading]FROM (((tblCustomers INNER JOIN tblSalesOrderAcks ON tblCustomers.[CustCode] = tblSalesOrderAcks.[CustAccount]) INNER JOIN tblSalesOrderLines ON tblSalesOrderAcks.[SalesOrderAckNo] = tblSalesOrderLines.[SalesOrderNo]) INNER JOIN (tblDeliveries INNER JOIN tblDeliveryLineNo ON tblDeliveries.[DeliveryNo] = tblDeliveryLineNo.[DeliveryNo]) ON tblSalesOrderLines.[SalesOrderLineNo] = tblDeliveryLineNo.[SalesOrderLineNo]) INNER JOIN (tblInvoice INNER JOIN tblInvoiceLineNo ON tblInvoice.[InvoiceNo] = tblInvoiceLineNo.[InvoiceNo]) ON tblDeliveryLineNo.[DeliveryLineNo] = tblInvoiceLineNo.[DeliveryLineNo];
Thanks