If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Multiple line items in quote
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 |
#2
|
|||
|
|||
Multiple line items in quote
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. -- Good Luck :-) Graham Mandeno [Access MVP] Auckland, New Zealand "dan dungan" wrote in message ... 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 |
#4
|
|||
|
|||
Multiple line items in quote
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 |
Thread Tools | |
Display Modes | |
|
|