The tables are part of a database that is an interface to a webstore. The
webstore takes the orders and the database manages the business. Sales from the
webstore are batch processed by the database. At the end of each day, all the
individual sales for the day are saved to a textfile and FTPed to the database.
At the database, many sales records are saved to TblSales and the corresponding
line items are saved to TblSalesDetails. The inventory for each product that was
sold that day then needs to be updated in TblProduct. So to know which products
were sold, a non-duplicates list needs to be generated from the records that
were added to TblSalesDetails that day.
"Tom" <th******@earthlink.net> wrote in message
news:NT*****************@newsread1.news.atl.earthl ink.net...
I have the standard tables: TblProducts, TblSales and TblSalesDetails.
SalesDetails records the Products that were on each sale. How can I get a
non-duplicate list of the products that were sold from the SalesDetails table
that is editable?
Thanks!
Tom