View only data based on a unique column value

[Roger_Wareham]

OK lets try to explain this one.

I want to have a view only showing unique value base on one column.

The database has lots of location numbers but when the user submits a new review of that location the old review would then not show.

I need this happening so I can have historic data on the location and don’t want to just update the existing review.

Is this possible to do in a view?

Thanks