Greetings All, I'm hoping someone can help with a table field qualification problem I've been trying to figure out.
Form A has a table field that shows all entries from Form B where 'UserID' on Form A = 'UserID' on Form B. I need to have 3 drop-down menus on Form A that can be used to "filter" the table. The user should be able to choose a value in any one of these menus to further refine the table field qualification. These menu fields are copies of fields from Form B with an extra option added in the Attributes for "Show All." So, if the menu field on Form B has values of 0, 1, and 2, the corresponding menu field on Form A will have values of 0, 1, 2, and 3 with the 3 being "Show All." If I use the EXTERNAL feature so that the table qualification is dynamic, what happens if the user doesn't use the menus on Form A, or only chooses a value other than "Show All" on 1 or 2 of them? For example, I have the following qualification: 'UserID' = $UserID$ AND 'Field1' = EXTERNAL($menu1$) AND 'Field2' = EXTERNAL($menu2$) AND 'Field3' = EXTERNAL($menu3$) However, if the menu on Form A is "Show All" then I need the qualification to ignore the 'Field' = EXTERNAL($menu$) bit of the qualification so that it brings back all entries regardless of the value of 'Field'. Does this make sense? _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
