A
Asif Rehman
Hello
I created a database for invoicing purposes and have 4
tables of many (Products, Customers, Orders, Order
Details) linked to create a form called orders for
invoicing.
In the products table I have a unit price field which
displays the price of an item when selected in the orders
subform which is a datasheet. I would like to have 3
mulitple price bands so depending on where the customer is
located is how much they will have to pay for the
product.
I have created a price band field in the customers table
and three other unit prices in the products table. How do
I get the subform to look at which price band the customer
falls into when they are selected and then display the
price of the product when it is selected in the subform
datasheet.
Any help will be much appreciated.
Kindest Regards
Asif
..
I created a database for invoicing purposes and have 4
tables of many (Products, Customers, Orders, Order
Details) linked to create a form called orders for
invoicing.
In the products table I have a unit price field which
displays the price of an item when selected in the orders
subform which is a datasheet. I would like to have 3
mulitple price bands so depending on where the customer is
located is how much they will have to pay for the
product.
I have created a price band field in the customers table
and three other unit prices in the products table. How do
I get the subform to look at which price band the customer
falls into when they are selected and then display the
price of the product when it is selected in the subform
datasheet.
Any help will be much appreciated.
Kindest Regards
Asif
..