Not to sure. There are more than 1 records but there are not duplicates.

Its just that there can be multiple entries for each address.

I need to create a view so that the view can be queried.

I assume that the criteria of which record of the bunch will be specified when querying the view.