locked
Tabular form with query, additional text boxes and command button RRS feed

  • Question

  • Hi all,

    I need to create a tabular form that queries from a table with a condition. I need also this form to include additional text boxes to enter values manually and a command button to post all the rows in another table.

    Details:

    The form should apply the query which fills the form rows

    SELECT Code, Model, Needed_Qty from Stock WHERE Needed_Qty > 0

    I want additional five rows of text boxes to enter manually Models that are not available in the Stock table as follows:

    Code          Model          Needed_Qty

    Code          Model          Needed_Qty 

    Code          Model          Needed_Qty 

    Code          Model          Needed_Qty

    Code          Model          Needed_Qty

    Finally I want a command button that post all the rows in this form to the table LoPI (List of Purchase Items) which has the following fields:

    Code            Model         Quantity


    • Edited by aziz_d99 Wednesday, January 14, 2015 4:51 AM
    Wednesday, January 14, 2015 4:47 AM