Hi
I have created a quoting and invoicing database
Four tables which work on a one to many relationship with the linking field the enquirynumber
tblEnquiry includes details of enquiry, ie address, client, enquiryNo, make and model of car etc
tblLabourEnquiry includes labour types, costs and enquiryno
tblPartEnquiry includes part description, partcost, part qty
tblPaintEnquiry includes painttype, repairtype, partpainted, paintcost
Problem I have is that one enquiry may have 2 labour types(so 2 records in tblLabour Enquiry), 10 parts(so 10 records in tblPartEnquiry) and 20 Paint Types(so 20 records in tblPaintEnquiry)
Problem is when I try to bring them together in a query based upon the enquiry number I end up with multiple lines returned in the query all repeating the same information from the tables.
Could someone point me in the right direction as to how to only show the correct number of records from each table without them multiplying up.
Thanks
Richard
I have created a quoting and invoicing database
Four tables which work on a one to many relationship with the linking field the enquirynumber
tblEnquiry includes details of enquiry, ie address, client, enquiryNo, make and model of car etc
tblLabourEnquiry includes labour types, costs and enquiryno
tblPartEnquiry includes part description, partcost, part qty
tblPaintEnquiry includes painttype, repairtype, partpainted, paintcost
Problem I have is that one enquiry may have 2 labour types(so 2 records in tblLabour Enquiry), 10 parts(so 10 records in tblPartEnquiry) and 20 Paint Types(so 20 records in tblPaintEnquiry)
Problem is when I try to bring them together in a query based upon the enquiry number I end up with multiple lines returned in the query all repeating the same information from the tables.
Could someone point me in the right direction as to how to only show the correct number of records from each table without them multiplying up.
Thanks
Richard
