Alpha Video Training
Results 1 to 2 of 2

Thread: List control detail view: filter a sql select statement on the value of another control in the detail view

  1. #1
    Member bob9145's Avatar
    Real Name
    Bob Senski
    Join Date
    Jun 2009
    Posts
    810

    Default List control detail view: filter a sql select statement on the value of another control in the detail view

    Trying to use a dropdown list in a listcontrol detail view based on a select statemet that is filtered by another control in the group of detail view controls. Similar to a cascading drop down box however the parent control is a label control that already has a value. I need to capture this value and use it as a filter for the child drop down control.

    I tried using an argument, but it seems the list control sql builder does not allow this. How can I get this value and use it to filter the drop down box that is based on a separate sql table.

    Select customer.name where C_Id = the value of the C_ID control when the detail view is rendered

    Thanks,
    Bob

  2. #2
    Member bob9145's Avatar
    Real Name
    Bob Senski
    Join Date
    Jun 2009
    Posts
    810

    Default Re: List control detail view: filter a sql select statement on the value of another control in the detail view

    Got this to work as a lookup field that allows you to filter with the value of a control on the record you are updating. Looks a little different than a drop downbox, and requires an ajax callback that is a little slow.

Similar Threads

  1. Excel/ASCII import into List Control with detail view
    By WindForce in forum Mobile & Browser Applications
    Replies: 1
    Last Post: 12-22-2014, 11:48 PM
  2. Shortcuts for moving from grid with UX to List Control with Detail View?
    By WindForce in forum Mobile & Browser Applications
    Replies: 6
    Last Post: 11-27-2014, 06:03 AM
  3. Refreshing detail view of List Control
    By rvanderbes in forum Mobile & Browser Applications
    Replies: 2
    Last Post: 10-23-2014, 01:38 PM
  4. List Control's Detail View Number Formatting
    By cawright in forum Mobile & Browser Applications
    Replies: 2
    Last Post: 09-20-2014, 09:33 AM
  5. Is anyone using the the detail view under with the list control?
    By MichaelCarroll in forum Mobile & Browser Applications
    Replies: 1
    Last Post: 06-15-2014, 11:56 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •