If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Multiple categories determine rates ..how to?
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. -- Thanks n Regards, Z |
#2
|
|||
|
|||
Zurghew wrote:
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. -- Joseph Meehan 26 + 6 = 1 It's Irish Math |
#3
|
|||
|
|||
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 ____________________________________ "Zurghew" wrote in message ... 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. -- Thanks n Regards, Z |
#4
|
|||
|
|||
"Joseph Meehan" wrote in message ... Zurghew wrote: 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. 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 -- Joseph Meehan 26 + 6 = 1 It's Irish Math |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Base data on Multiple categories | Zurghew | General Discussion | 2 | December 1st, 2004 04:29 AM |
Contact categories data blank - mismapping? | Peter Lunn | Contacts | 1 | May 18th, 2004 12:13 AM |
Suppressing categories with 0 values | Confusious | Charts and Charting | 1 | May 16th, 2004 09:03 AM |
Multiple Many-To-Many Tables | Tom | Database Design | 7 | May 15th, 2004 03:47 AM |
Stacked Columns with multiple categories | Erik | Charts and Charting | 2 | October 14th, 2003 05:26 PM |