Relationship Links

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 ?
 

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