Multiple categories determine rates ..how to?

[Zurghew]

Hi all,

Second post please please help me here. I need to have a form which will
allow me to select a
particular type of service through a combo box and based on that value
choose another subcategory and based on that subcategory choose another
subcategory and then according to the item selected store the rates in the
table transaction. Also some of the servie do not have subcategories i.e;
just choosing the service will give a rate.

Graphically, (pls excuse if not clear)

combo1--choose-->Service(CategoryA)...based on catA choose from
combo2------>
SubCategoryA---based on SubCategoryA choose from combo3---->
SubSubCategoryA......based on this combination of all the three multiple
categories I plan to have the rates field filled up.

I have no idea how to acheive this any tips will be of great help.

 

[Joseph Meehan]

Hi all,

Second post please please help me here. I need to have a form which
will allow me to select a
particular type of service through a combo box and based on that value
choose another subcategory and based on that subcategory choose
another subcategory and then according to the item selected store the
rates in the table transaction. Also some of the servie do not have
subcategories i.e; just choosing the service will give a rate.

Graphically, (pls excuse if not clear)

combo1--choose-->Service(CategoryA)...based on catA choose from
combo2------>
SubCategoryA---based on SubCategoryA choose from combo3---->
SubSubCategoryA......based on this combination of all the three
multiple categories I plan to have the rates field filled up.

I have no idea how to acheive this any tips will be of great help.

What is your table structure? You need to get that set up to meet your
planed needs first.

 

[Tom Wickerath]

From your description, it sounds like you want to implement synchronized combo boxes. Here are
two links to KB articles that give you a "how-to" tutorial on this subject:

http://support.microsoft.com/?id=209595

http://support.microsoft.com/?id=209576


Tom
____________________________________


Hi all,

Second post please please help me here. I need to have a form which will
allow me to select a
particular type of service through a combo box and based on that value
choose another subcategory and based on that subcategory choose another
subcategory and then according to the item selected store the rates in the
table transaction. Also some of the servie do not have subcategories i.e;
just choosing the service will give a rate.

Graphically, (pls excuse if not clear)

combo1--choose-->Service(CategoryA)...based on catA choose from
combo2------>
SubCategoryA---based on SubCategoryA choose from combo3---->
SubSubCategoryA......based on this combination of all the three multiple
categories I plan to have the rates field filled up.

I have no idea how to acheive this any tips will be of great help.

 

[Zurghew]

What is your table structure? You need to get that set up to meet your
planed needs first.

My tables are as follows:
tblCustomers
-------------
CustomerID (P,K)
Name
Address
etc
tblWork
--------
WorkID(P,K)
WorkRequestNo
WorkReqdate
CustID (F,K)

tblWorkDetails
---------------
WorkDetailsID (P,K)
WorkID (F,K)
TypeOfService ...eg; Coding, Scanning, Editing
ServiceSubCategory eg: VB, Java, C, C++, Perl etc ....there may or may not
be Servicesubcategory
SubSubCategory * there may or may not be subsubcategory*
SubSubSubCategory * there may or maynot be SubSubCategory*
AnotherTypeof Service *Separate type of Work*
Employee (F,K)

TblCharges ** I have this table with all the rates in it ..around 20
lines.Some of them do not have any values in subcategory only typeofservice
and rates**
----------
ChargeID (P,K)
TypeoFService
Category
Sub Category
SubSubCategory
SubSubCatgeory
rates

I need to look up details of rates when I enter a workrequest with different
types of services selected.
Pls help