AnsweredAssumed Answered

Return Fields Based on Form Entry

Question asked by on Aug 1, 2017
Latest reply on Aug 7, 2017 by emha

I have a list with the following columns:


Vendor    Type       Role         Location         Price Year 1         Price Year 2      Price Year 3



I need to have a form which I can input a price and it will search years 1,2 and 3 and return any matches with all the rest of the record.


So for instance on the form I would have a place to input a rate. If the rate was in a record in year 2 I would pull the other field values into the form.


Rate: $100.00


Vendor      Type               Role      Location         Year 1      Year 2         Year 3

IBM            Onshore         PM      New York                          $100.00

Samsung   Offshore         AVP      New Deli                           $100.00


I have been trying to do this with a list lookup but feel there may be a better way to do this.