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.