-
Lisa Rudnitsky
- InfoMaker
- Wednesday, 26 February 2020 08:07 PM UTC
Hello,
I am trying to build a custom screen inside our software using infoamker. where two menus are related. (This lives on a constituent account (on the same ID)).
MenuA has values and MenuB has values.
A user selects a value from MenuA and that filters down the possible values in MenuB.
A user selects a program, and prior to hitting save the values in curriculum are no limited by the program.
User selects Secondary the curriculum values displayed are only Bowie and Dylan.
The relationship between program and curriculum live in one local/system table.
Has anyone done anything like this, with this relationship? Please tell me its feasible and I would love any guidance/advice on how to accomplish it.
For example.
ID PROGRAM Curriculum
1 Elementary Presley
2 Elementary Jackson
3 Elementary Hendrix
4 Secondary Bowie
5 Secondary Dylan
This is MenuA (Program)
SELECT C_PROGRAM.prog_id as main_prog_id,
C_PROGRAM.program
FROM C_PROGRAM
ORDER BY C_PROGRAM.program asc
This is MenuB (Curriculum Track)
SELECT LTR_Program_Track.id as 'Main_Prog_id',
C_PROGRAM.Prog_id as 'Prog_ID',
LTR_Program_Track.tracks as 'Tracks'
FROM LTR_Program_Track
JOIN C_PROGRAM on C_PROGRAM.prog_id = LTR_Program_Track.wmi_program
WHERE C_PROGRAM.Prog_id = :main_prog_id
ORDER BY LTR_WMI_Program_Track.tracks asc
Someone quickly suggested the following, but isn't available to elaborate any further:
Their examples was:
MenuA
SELECT
id season_id,
description season_desc,
fyear,
inactive,
start_dt
from TR_YEAR
MenuB
SELECT prod_season_no prod_season_id,
i.description prod_season_desc,
ps.season season_id
from T_PROD_YEAR ps
join T_INVENTORY i on i.inv_no = ps.prod_season_no
where ps.season = :season_id
The filtering of MenuB is effected by having {prod_season_desc, season_id} in the Tag field of the underlying id field
-----------
However, the above is a little unclear to me.
--------------
Just to add, I have a parent file called ud_school_dig_screen in that screen i have the above listed menus, menuA and menuB.
Please let me know if any further information could be helpful to help sort this issue out.
Thank you.
-Lisa
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.