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
|
|||
|
|||
Regulating available options
I have a table called tbl_class_type_cat. The table looks like this:
ClassID Class Type Category 1 C1 Customer Incorrect 2 C1 Customer Correct 3 C1 Client Invalid 4 C1 Client Incorrect 5 C1 Client Correct 6 C2 Customer Incorrect 7 C2 Client Correct So using this table I need to create a form with three fields that look like this: Class: Type: Category: I want the Class Field to have C1 and C2 available Based on which selected only certain options will be available. So if I selected C1 then the Categories available would be Customer and Client. If Customer is selected then Incorrect and Correct would only be available in the Category. The actual Class Id will be stored in a seprate table that links to additional data. Any help would be appreciated! -- Message posted via http://www.accessmonster.com |
#2
|
|||
|
|||
Regulating available options
ladybug -
These are called cascading list boxes. Look at this site for help in creating them: office.microsoft.com/en-us/infopath/HA011177131033.aspx -- Daryl S "ladybug via AccessMonster.com" wrote: I have a table called tbl_class_type_cat. The table looks like this: ClassID Class Type Category 1 C1 Customer Incorrect 2 C1 Customer Correct 3 C1 Client Invalid 4 C1 Client Incorrect 5 C1 Client Correct 6 C2 Customer Incorrect 7 C2 Client Correct So using this table I need to create a form with three fields that look like this: Class: Type: Category: I want the Class Field to have C1 and C2 available Based on which selected only certain options will be available. So if I selected C1 then the Categories available would be Customer and Client. If Customer is selected then Incorrect and Correct would only be available in the Category. The actual Class Id will be stored in a seprate table that links to additional data. Any help would be appreciated! -- Message posted via http://www.accessmonster.com . |
Thread Tools | |
Display Modes | |
|
|