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

    Repetition Field and Lookup

    sugarking

      Title

      Repetition Field and Lookup

      Post

      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

       

      thanks....