Ok I cant find anything like this on here so I'm assuming its really easy and I'm just a fool. However I cant figure it out so here goes.
I have a form with a list of ALL of our products on it, we supply different products to certain companies at a different price so the product list has grouping options for each of these price lists.
Currently if you open the product list form it shows all products for all companies and looks like this:
_______________________________________
|Price Group | ProductID | Description | Price | Unit|
---------------------------------------------------------------
Which is all well and good but I want a way for my users to filter the results in one of three ways
1: Filter by price group and productID to find the price for a specific product under a certain price list
2: Filter by product code to compare prices for one product against all clients
3: Filter by price list to view all of the products under the specific price list.
I wish this filter method to also apply to the report so the report built on this table will also be filtered in the appropriate way.
The search boxes should go in the form footer and be really easy to use as all of the users of this database are completley computer illiterate.
Finally each search must be automatically wildcarded at both ends ie: *productID*
-----------
Sorry if this is a really daft question but I cant figure out how to do it.
I have a form with a list of ALL of our products on it, we supply different products to certain companies at a different price so the product list has grouping options for each of these price lists.
Currently if you open the product list form it shows all products for all companies and looks like this:
_______________________________________
|Price Group | ProductID | Description | Price | Unit|
---------------------------------------------------------------
Which is all well and good but I want a way for my users to filter the results in one of three ways
1: Filter by price group and productID to find the price for a specific product under a certain price list
2: Filter by product code to compare prices for one product against all clients
3: Filter by price list to view all of the products under the specific price list.
I wish this filter method to also apply to the report so the report built on this table will also be filtered in the appropriate way.
The search boxes should go in the form footer and be really easy to use as all of the users of this database are completley computer illiterate.
Finally each search must be automatically wildcarded at both ends ie: *productID*
-----------
Sorry if this is a really daft question but I cant figure out how to do it.