Skip to main content

Search

Search

Query Prompt and Table Control - Dynamic/Scanned data to key Database Table Object

Comments

3 comments

  • Avatar
    Peter Thane

    Sorry, I am not an SQL programmer, but I believe you will need to add something like this to your Custom SQL statement:

    WHERE `ProductCode` = '?QueryPrompt1'

    In the above ProductCode is the field I am searching for the parameter in for the paramater that is entered in QueryPrompt1 (you can give this a different name as long as it follows the same convention with the leading "?".

    Once your query prompt has been defined then on your Data Entry Form you will be able to link to this Query Prompt.

    I hope this helps

     

    0
  • Avatar
    Robert Hayes

    Thanks, Peter.   This one is weird - the label prints fine when using the query prompt alone (no form) but won't populate both the header & table data when I switch to using a Data Entry form.  Think the table control is calling the DB before the QP is set...

    0
  • Avatar
    Peter Thane

    So you have a query prompt and then this populates a table with a number of records and then you choose one from there?

    If so, you could try adding a 2nd Data Entry Form and add the table to that. 

    0

Please sign in to leave a comment.