473,320 Members | 1,988 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Non-Duplicate List Of Products

Tom
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
Nov 12 '05 #1
3 1536
Tom previously wrote:
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?


You can't. It doesn't make any sense to do so.
You have to edit specific records (in the tblSalesDetails table). Once
you group records by product then you are no longer looking at specific
records but at summary stats.

What are you trying to achieve?

Peter Russell
Nov 12 '05 #2
You can, but it still doesn't make sense to me why you would want to...

a SELECT DISTINCT as the root of a MakeTable query or the condition to
populate a recordset would do the trick... This will only give you one
instance of each product id in the details table. You can edit this all you
want, but to what end???


"Peter Russell" <ru***@127.0.0.1> wrote in message
news:me***********************@russellscott.btinte rnet.com...
Tom previously wrote:
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?


You can't. It doesn't make any sense to do so.
You have to edit specific records (in the tblSalesDetails table). Once
you group records by product then you are no longer looking at specific
records but at summary stats.

What are you trying to achieve?

Peter Russell

Nov 12 '05 #3
Tom
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

Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: klaus triendl | last post by:
hi, recently i discovered a memory leak in our code; after some investigation i could reduce it to the following problem: return objects of functions are handled as temporary objects, hence...
3
by: Mario | last post by:
Hello, I couldn't find a solution to the following problem (tried google and dejanews), maybe I'm using the wrong keywords? Is there a way to open a file (a linux fifo pipe actually) in...
32
by: Adrian Herscu | last post by:
Hi all, In which circumstances it is appropriate to declare methods as non-virtual? Thanx, Adrian.
8
by: Bern McCarty | last post by:
Is it at all possible to leverage mixed-mode assemblies from AppDomains other than the default AppDomain? Is there any means at all of doing this? Mixed-mode is incredibly convenient, but if I...
14
by: Patrick Kowalzick | last post by:
Dear all, I have an existing piece of code with a struct with some PODs. struct A { int x; int y; };
11
by: ypjofficial | last post by:
Hello All, So far I have been reading that in case of a polymorphic class ( having at least one virtual function in it), the virtual function call get resolved at run time and during that the...
2
by: Ian825 | last post by:
I need help writing a function for a program that is based upon the various operations of a matrix and I keep getting a "non-aggregate type" error. My guess is that I need to dereference my...
0
by: amitvps | last post by:
Secure Socket Layer is very important and useful for any web application but it brings some problems too with itself. Handling navigation between secure and non-secure pages is one of the cumbersome...
399
by: =?UTF-8?B?Ik1hcnRpbiB2LiBMw7Z3aXMi?= | last post by:
PEP 1 specifies that PEP authors need to collect feedback from the community. As the author of PEP 3131, I'd like to encourage comments to the PEP included below, either here (comp.lang.python), or...
12
by: puzzlecracker | last post by:
is it even possible or/and there is a better alternative to accept input in a nonblocking manner?
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.