D
deiopajw
I'm having trouble with linking certain tables in the relationships section.
I have the following:
*tbl_customer
CustID Prim key (autonumber)
fkeyMarketingID (number)
CompName
CompAddr
*tbl_Quote
QuoteNo Prim key (autonumber)
fkeyCustID (number)
ContactName
ProjectName
SiteAddr
*tbl_QuoteDetails
fkeyQuoteNo (number)
fkeyProductID (number)
Panel
Length
Thickness
The following table is simply reference data, no additions allowed to this
table.
*tbl_Product
ProductID Prim key (autonumber)
ProductName
Numbinpack
*tbl_Ancillaries
AncID Prim key
AncName (reference data like the Productname above)
AncQty
AncPrice
so far the relationships are like this:
tbl_customer (one) ------- (many) tbl_Quote
tblQuote (one) ------------(many) tbl_QuoteDetails
tbl_QuoteDetails (many) ------- (one) tbl_Product
For each quote number, there may be several different productnames to add
and the same product may be used more than once in the same quote number.
eg: Quote 1:
Product A, thickness 50 Length 2
Product A, thickness 30 Length 1
Product B, thickness 35 Length
This is my problem: I can't link the ancillaries table anywhere in the
relationships area without getting some error message.
With the ancillaries, you can select several different types for a given
quote number BUT you cannot select the same type of ancillary again for the
same quote number.
eg. quote 1: S1 qty:3 price: $33
S3 qty: 5 price: $56
S5 qty 6 price: $12
Where can I link the ancillaries table to ?
I have the following:
*tbl_customer
CustID Prim key (autonumber)
fkeyMarketingID (number)
CompName
CompAddr
*tbl_Quote
QuoteNo Prim key (autonumber)
fkeyCustID (number)
ContactName
ProjectName
SiteAddr
*tbl_QuoteDetails
fkeyQuoteNo (number)
fkeyProductID (number)
Panel
Length
Thickness
The following table is simply reference data, no additions allowed to this
table.
*tbl_Product
ProductID Prim key (autonumber)
ProductName
Numbinpack
*tbl_Ancillaries
AncID Prim key
AncName (reference data like the Productname above)
AncQty
AncPrice
so far the relationships are like this:
tbl_customer (one) ------- (many) tbl_Quote
tblQuote (one) ------------(many) tbl_QuoteDetails
tbl_QuoteDetails (many) ------- (one) tbl_Product
For each quote number, there may be several different productnames to add
and the same product may be used more than once in the same quote number.
eg: Quote 1:
Product A, thickness 50 Length 2
Product A, thickness 30 Length 1
Product B, thickness 35 Length
This is my problem: I can't link the ancillaries table anywhere in the
relationships area without getting some error message.
With the ancillaries, you can select several different types for a given
quote number BUT you cannot select the same type of ancillary again for the
same quote number.
eg. quote 1: S1 qty:3 price: $33
S3 qty: 5 price: $56
S5 qty 6 price: $12
Where can I link the ancillaries table to ?