1. Lisa Rudnitsky
  2. InfoMaker
  3. Wednesday, 26 February 2020 20:07 PM UTC


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, 
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: 


id season_id,
description season_desc,
from TR_YEAR


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. 

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 26 February 2020 20:33 PM UTC
  2. InfoMaker
  3. # 1

Hi Lisa;

  You listed this question under InfoMaker. Did you mean this to be a PowerBuilder question?

Regards ... Chris

There are no comments made yet.
Lisa Rudnitsky Accepted Answer Pending Moderation
  1. Wednesday, 26 February 2020 20:38 PM UTC
  2. InfoMaker
  3. # 2

Hello Chris,
Please correct me if i'm wrong but my understanding is that infomaker is a power builder application? and its under appeon now. I'm sorry if i have my terminology off, but i am referring to infomaker and i am using it to build data modules/custom screens a we call them in our application. 
thank you

  1. Chris Pollach @Appeon
  2. Wednesday, 26 February 2020 20:49 PM UTC
Hi Lisa;

Thank you for confirming that you are using IM. I asked this because IM does *not* allow you control over any Menu objects or their Menu Items - whereas, PB does. So to answer your question (if I interpret it correctly) is ... "you cannot do that in IM" as the menus are "stock" (hidden) inside the IM product. That is the Menu's that you see when you build an App EXE built from the Library Painter.

Note: If yo have a PB developer in your organization, they can have access to the IM "templates" (including menus) where it would be possible to add menu dependency. The other alternative for the PB developer is to take your Reports / Forms and build a more sophisticated App like you seem to indicate using PowerBuilder.


Regards ... Chris
  1. Helpful
There are no comments made yet.
Lisa Rudnitsky Accepted Answer Pending Moderation
  1. Thursday, 27 February 2020 14:46 PM UTC
  2. InfoMaker
  3. # 3

Good morning Chris, 

Thank you for the detailed response, we are limited in what we can do. Is there any work around or other ideas that can help accomplish linked menus with infomaker. Is there no way to create a trigger or to use the sql behind it in some way?

Thank you again, 

There are no comments made yet.
  • Page :
  • 1

There are no replies made for this question yet.
However, you are not allowed to reply to this question.