Queries making multiple records

  • Thread starter Thread starter Sarah
  • Start date Start date
S

Sarah

Hi, I have just started writing my database all over again, cause i was
advised that it was incorrect the first time eg, relationships, tables etc.
Well i think the penny has finally dropped and now i think i know what i am
doing (not really sure though), i have fixed all the relationships and tables
etc, I have used "normalization forms" and with that i have put on one
table description and qty and the other table i have put description qty and
price. I have linked these with a query using the Primary Key which i have
used what type of part it relates to so that all the descriptions have an
identifing key. Now the problem i have is that when i now look at the query
it has made duplicate lines, from the auto number? What have i done wrong?
is it because i have used an auto number on all the lines? Please help.
Thanks sarah
 
Hard to tell what you're trying to do here, but only 1 table should have the
fields description and quantity. Look at the inventory template that ships
with Access. There you'll find tables and relationships that you can modify
for your own use. Typically, there is:

Product table
ItemID
Item Description
ProducerID
etc.

Producer table
ProducerID
ProducerName
etc.

Customer table
CustomerID
LastName
FirstName
etc.

Order table
OrderID
CustomerID
ItemID
Date
etc.

Order Details table
OrderID
Price
Quantity
etc.

Use the ID fields to relate the tables - good luck!
 
View your query in SQL view (one of the View options when you query is
open). Copy the SQL text and post it here - might help one of us spot the
problem.

Phil, London
 
Hi,

Thanks for that, i had my "normalization" tables incorrect. I hadnt spilt
them between what was need and what wasnt needed.

Thanks for your help.

Cheers
Sarah
 
Back
Top