4 Replies Latest reply on Jul 23, 2009 12:51 PM by mrvodka

    Repetition Field and Lookup



      Repetition Field and Lookup


      Hi Friends,

      I have a situation and need some help.

      I have a very simple database that has three fields :


      ProductID ( this is Text field and it is also a  lookup field with a control style (edit box) that show all the values from another table for me to select ). It also has been set to do a vertical repetition for 8 fields.


      Product  ( is also a text field and i will like to show the description of the product here ) I have used also a repetition to create 8 fields. ) The description should come from the selectio of the produtID.


      Quantity ( a numeric field )


       Price (numeric)


      Total ( a calculation field that takes the price times the quantity )


      In the end this is like a purchase order. But, i will like to select or enter in the stockid field the item and then repeat the question for the other 7 items and be able to show the descrption for each item. In other words,


      ProductID        Description  Quantity Price  Total

      100                PENS               1         2       2

      200                PENCILS          10        5       50


      HERE, i only enter the 100 but i also have a control stlye edit box that shows me all the items.


      My problem is : that whenever i select the 200 item PENCILS wont appear in the second line, it will appear in the top line.


      i hope this is clear enough and look forward to receiving some help


      i am stuck