AnsweredAssumed Answered

Return Fields Based on Form Entry

Question asked by slwhite63@gmail.com 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.

Outcomes