1 Reply Latest reply on Nov 30, 2008 6:24 AM by Jens Teich






      Hello, I am new in FP and need some help. I am trying to make an invoice database. In one text field I created the diferent items with its name (text field). I created a second field with the price (numbers field), but I have to enter manually the price. What I want to do is to relate both fields, so when I select in the items field the name of the item I want that its price could fill the price field automatically. How can I do that? Thanks

        • 1. Re: Fields
          Jens Teich
             There are some tables missing:

          - 'line items' with a record for each item of the invoice
          - 'article' with all your articles. Fields are name, description an price.

          In table line items you add a field ID_article and get the price by reference from the article table.