Multiple line items in quote

D

dan dungan

Hi,

Using Access 2000 and Windows XP, I've looked at northwind to see a
model for the table design of my quoting project, but I'm still
confused because a customer can request more than one quantity for a
part number--They may request 3 or 4 different quantities. So do I
need a quotedetaildetail table?

Thanks,

Dan

I've tables as follows:

---------------------------------------------------------------
tblCustomer
CId 1
CCompName HARVARD CUSTOM

---------------------------------------------------------------
tblEmployee
EmployeeId 1
FirstName Molly
LastName Brown
---------------------------------------------------------------
tblQuote
QuoteNum 124
CId 1
EmployeeID 1
CRefNum H009
Date 3/26/2009
Time 8:58 AM
---------------------------------------------------------------

tblQuoteDetails
QuoteDetailId 1
PartNumId 15
Quantity 25
UnitPrice $56.08
Delivery 8 Weeks
 
G

Graham Mandeno

Hi Dan

The only thing that would stop you having multiple records in
tblQuoteDetails with the same QuoteNum and PartNumID is if you have a
composite index on those two fields that does not allow duplicates.

I have not had a look at NorthWind for a while, but it's possible they have
put such an index on the order details table exactly to prevent the same
product from appearing twice in one order.

If your requirements are different then simply delete that index.
 
S

Steve

No, you would enter the 3 or 4 different quantities as 3 or 4 line items.

Two things I see about your tables ....
1. You need a parts table that looks something like :
TblPart
PartID
PartDesc
UnitPrice
2. You need the field QuoteNum in TblQuoteDetails. Then create a
relationship between it and QuoteNum in TblQuote.

Steve
(e-mail address removed)
 
D

dan dungan

Thanks for your response Graham.

I'm still confused, however. I'm attempting to clarify my questions.
I'll post back when I have a more defined question.

Dan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top