i have an checkbox to which i have assigned an table…now what i want to know is that, how i will filter this table so that the user see only certain fields…i tried using RunformView[*-)]…but dunno how well to use it i guess[:@].
for eg :- i have an table with students mark,roll,name,chemistry,biology,phys.
so how do i use runFormview ,so that i only chemistry values along with the others (mark,roll,name)…
Do you plan to have a seperate form per study type?
If so, the correct filter would be Chemistry, CONST, Yes.
Otherwise you should not use the form view but have an option selection on the top of the form (similar to Report Selections form) and change filter by code when changing the value in this option field.
My fields are decimal fields, so cant use const i think!..And i will attach my snap here…in methodylogy there are serveral, but i have kept only 1 here, so when i click the methodology and the resource! only the resurces i selected should appear in the form…
I’m a bit confused with the screenshot you’ve attached. What are you trying to EXACTLY?
a) Are you trying to Filter Resources based on Methodology, Practice etc?
b) Are you trying to get the filters first and then display a form based on the selection?
c) What and where is the Decimal fields you’re talking about?
So lets call them as practise here…but a person(say myself) is working on NAV! so i can access only NAV details. but the company has all the details of all the practise!
clear till now?
now…when i select NAV in the Practise…All the method & resources opening will be of NAV details…
But Not all person can access all datas even in NAV…I am an Technical person, so i can access only technical details! thats is where Methodology cames…then i want to view only particular datas in the methodology! so comes the Resouces!
(a) You want to show Form A to the User with say only the first line of Check Boxes (i.e. for Navision, SAP etc)
(b) Based on his selection, you want to display further available choices for the user to select filtering at each level
(c) Finally when all the details are selected, you want to run another Form B filtering for the details provided in Form A.
I tried out a Small Example by writing code on OnPush of the CheckBox button. Here’s something that can help you.
a) First place all the CheckBoxes and assign SourceExpressions to them (Boolean Values)
b) Go to the Property of the CheckBox control and Give Each Control a NAME
c) On the OnPush Trigger of a CheckBox write code to Conditionally Show (Enabled) or Hide (Disable) other following boxes.
d) Finally based on the choice, call another form.
Here is a small code snippet I tested.
if a = FALSE then
CurrForm.B.ENABLED := FALSE;
CurrForm.C.ENABLED := FALSE;
if a = TRUE then
CurrForm.B.ENABLED := TRUE;
(Small letter ‘a’ is the SourceExpression and ‘B’ and ‘C’ are the values in the NAME field)
This is clearly an example of NOT KNOWING WHAT YOU ARE TRYING TO DO. Had I been developing such a Form, I would’ve known what buttons will appear at what time.
It is very important to ‘think it through’ before you start. If you want:
a) Methodology, Resource buttons to appear after a User clicks Practice, then you’ve to write code in the CheckBoxes of Practice.
b) If you want to show all the buttons for the user selection, and then show him the main form at once, write your code in the SHOW button.