×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Sybase/Infomaker field dependency

Sybase/Infomaker field dependency

Sybase/Infomaker field dependency

(OP)
Hello,

I am working on a Custom screen in sybase - infomaker 12.0 (for the Tessitura application).

The screen has 6 data fields that pull from a separate data window.
They pull a description field (to display) and an id field (to store). What I would like to do is limit (in infomaker) the users drop down options.

If they've already selected option1 in the first drop down, when they go to option2 in the second drop down option1 won't appear. (all theoretically without clicking save).

We have

Genre 1: If Jazz is selected here.

Genre 2: Jazz should no longer be an option here, if Classical is selected here.

Genre 3: Jazz and classical should not be options here.

etc.

There is the option to code a trigger in sql to say/pop up for the user after they've saved saying "don't do that" but what i would like is to have the drop down be limited/updated based on the previous selection.

The data is pulled from a reference table we create and users populate as they need to - and selected in a separate data window in infomaker.

~~~~~~~~~~~~~~~~~~~~~~~
I should add I've taken the instructions apart in the Tessitura documentation - I found this but it's not very helpful, and has confused me more then helped me.

This language: It is possible to have dropdowns in custom screens dependent on the value in another column in the screen (added v6.5). See the datawindow, ld_program and the dropdown datawindow, ld_donation_level in UserReports.pbl for an example of how to use this functionality. Note the following (referencing the samples):

1. The column tr_donation_level_desc is a text column that retrieves the description value from the database. The visible property of the column is such that it only is visible on rows that are not the current row. It has a tag property of NOUPDATE, because it is not saved to the database.

2. This text column is positioned at exactly the same position as the dependant dropdown column, donation_level. The dropdown column donation_level has a visible property that makes it visible only on the current row.

3. The tag value for the dependant dropdown column donation_level is {tr_donation_level_description, program_no}. This array contains the following two values: the name of the column that is positioned over the dependant dropdown column; and the name of the column whose value is the retrieval argument for this dropdown.

4. The data column name must refer to a numeric column and the display column name must refer to a string column.

5. The dropdown datawindow ld_donation_level has a numeric retrieval arguement.

6. The donation_level column has the AutoRetrieve checkbox unchecked on the Edit tab in Infomaker. This prevents the dropdown from populating automatically

But I couldn't find the webinar and am a bit stuck on the instructions provided.

Thank you,

-Yelizaveta

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close