lookup field / calculated field RRS feed

  • Question

  • ok, I have a two lists.  the first is a vendor list with a vendor name and a vendor id.  The second is an invoice list.  On the invoice list, I have a column that is a lookup to choose the vendor name.  I would like to have another column on the invoice list that would get the vendor id based on the vendor name that was selected.  I was thinking that I would use a calculated column for this, but I'm not sure how.  Any ideas?
    Thursday, November 20, 2008 7:40 PM


  • create a calculated field and go in formula window and see if your field is listed there and simply put formula like

    =your field value.

    this will show the vendor id. however it will not refresh right away. it will show you vendor id on page referesh etc. If you want an interactive way of doing it, you will have to write your own EditForm.aspx and NewForm.aspx to acheive this using AJax.

    • Marked as answer by MDHunt Thursday, November 20, 2008 10:22 PM
    Thursday, November 20, 2008 7:49 PM