I know this is really simple but I'm struggling so if anybody could help me I'd be grateful. As a self-taught user of Access I understand too many of the details and not enough of the basics!! I just need an idea for a basic design of relationships and queries to process the following data:
table 1: a list of potential suppliers, each in a country
table 2: a list of customers and their details
I need to select one and only one supplier from each country for each customer, in order to perform some calculations that multiply values in table 1 by values in table 2, to come out with a total price for each selected supplier for the customer.