David, You do not need a table. You need a view. Here is a command that would create your view, if you typed it at the command line:
Create View LatestInvoices (CustNo, LatestInvoiceDate) + AS SELECT + CustNo, MAX(InvoiceDate) + FROM YourTableName + GROUP BY CustNo Then you will have the equivalent of a table, but it will always be up to date. You can use it in a lookup, you can base a report on it, you can browse it. Bill On Wed, Feb 26, 2014 at 8:52 AM, David Gideon <[email protected]> wrote: > I have a table that has the following columns. > > > > Custno Invoiceno invoicedate > > > > The table lists all customers and their invoice numbers and invoice dates. > > > > I need to create a table that has Custno and the latest invoice date for > that Custno. > > > > I am trying to use a command file to do this, but have not been able to > find the correct commands. > > > > I would appreciate any help you can provide. > > > > I have never used the R:Base list before so if I am not doing this right, > please let me know. > > > > Thanks > > > > *David C. Gideon* > > *Controller/Treasurer* > > > > *Builders Supply, Inc.* > > *8198 E 44th Street* > > *Tulsa, OK 74145* > > *Tel: 918-628-1211 <918-628-1211>* > > *Fax: 918-627-3710 <918-627-3710>* > > > > >
