Multiple line items in quote

[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

 

[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.

 

[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)

 

[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