I'm attempting to normalize a table that looks similar to this
Code:
Caller
Caller Address Block
Caller Address Street
Caller Address City
Location
Location Address Block
Location Address Street
Location Address City
Occurance
Occurance Address Block
Occurance Address Street
Occurance Address City
My first step was to get rid of the obvious and make it look like
Code:
Caller
Caller Address ID
Location
Location Address ID
Occurance
Occurance Address ID
When I look at that, it seems that several "...Address ID" columns qualifies as a repeating field. Should I move those into another table?

Thanks,
Mike