Hi,
Due to the way my system reports sales data, I have 2 tables that I'm not sure can be directly connected in a query. Table 1,tblSales, includes fields such as Customer Number, Part Number, Sales Value, etc. Table 2, tblContract, includes contract information for all of my customers such as loaded resale pricing, target margins, etc. Table 2, however, has Sub-Customer Number instead of the Customer Number found in Table 1. This sub number is used by our system to store pricing, and we allow all sorts of customers to "point" to this sub number to avoid from having to load the same pricing multiple times.
What I have tried to do for now is created a 3rd table called Pointer which contains the field Customer Number from Table 1 and its Sub Customer Number that would relate to it. I am trying to achieve bringing back my Resale field from Table 2 into the same record as customer sales data fields from Table 1 when I run the query, but I only get a bunch of duplicates. Both of these tables do share part numbers, but the customer #'s are different.
How can I properly join these tables in a query?
Thanks!
Due to the way my system reports sales data, I have 2 tables that I'm not sure can be directly connected in a query. Table 1,tblSales, includes fields such as Customer Number, Part Number, Sales Value, etc. Table 2, tblContract, includes contract information for all of my customers such as loaded resale pricing, target margins, etc. Table 2, however, has Sub-Customer Number instead of the Customer Number found in Table 1. This sub number is used by our system to store pricing, and we allow all sorts of customers to "point" to this sub number to avoid from having to load the same pricing multiple times.
What I have tried to do for now is created a 3rd table called Pointer which contains the field Customer Number from Table 1 and its Sub Customer Number that would relate to it. I am trying to achieve bringing back my Resale field from Table 2 into the same record as customer sales data fields from Table 1 when I run the query, but I only get a bunch of duplicates. Both of these tables do share part numbers, but the customer #'s are different.
How can I properly join these tables in a query?
Thanks!
Last edited:
