>So what is the Relational filed between InvoiceDetail and Status when There is Nostatus field in InvoiceDetail.
There is no relation between that. InvoiceDetail.NoStatus is simply a field in the detail table.
>Assuming Invoiceno, itself to be the relational filed try this SQL.
>
>SELECT MAX(Invoiceno) as InvoiceNo FROM Invoicedetail GROUP BY ;
>Invoiceno INTO CURSOR MAXINVOICE READWRITE && This Will Create a Cursor with all the latest (Last) Invoices
>
>*Alter This Cursor and add a filed Status7 and Status3.
>Alter Table MAXINVIOCE Add Column Status7 N(2) Add Column Status3 N(2)
>
>*Update Status7 and Status3 of All invoices in MAXINVOICE as per your need and delete.
You may take a look at the other message I created. That details the entire script that I have done.