I have a table with 2 fields, Name and transactionDate. The date field is a lookup field. My requirement is that I need just one entry in the table for one name. If the lookup field gets a new value for a particular name, it should replace the current row.
For example, if the table had a row with (ABC, 12/12/2013) and if a new entry comes with values (ABC, 10/8/2013) then the earlier row should be replaced. is this possible?