ok here it goes:

I am in process of creating a database here and need lots of help. Here is what i have done and then my question:

I have created the following tables:
Inventory (that has 2 different pricing available on it *A* & *B*
Customers (that has their ship to and bill to address on it...Have mulitple customers with one bill to but alot of different ship to)
CustomersPricing (list of customers and which catagory pricing they fall under)
MasterTable (to which all above are in a relationship with)

Now here is my delima...

I want that when a Customer calls in and its auto populated that it can be auto shown which prices they get for their inventory..I have it seperated on my Inventory table in fields..how can i refer when i populate any customer from one table/qry to another table/qry meaning a specific field in that other table