Hi Nakul, Grant, Lowell and Nevyn,

I'm really sorry not to have checked this further before posting. It seems I misunderstood where the reformatting was occuring.

It's only when I right-click the...

Ok, thanks Paul.

I did understand your post first time round. SCD is definitely the way to go with references to the name of B. I only posted again because I...

Absolutely right, this is the setup I currently have. But:

for the 90% of Bs which only have one A:

I want to present the user with the friendly name of...

Hi Paul,

thanks (again!) for your quick response!

I'm not sure I've properly explained the problem. The issue of whether a household has a name or not (and, hence, whether it is...

Hi again all,

apologies (and particular to Paul below!) for not being clearer.

The TV licences example was purely fictitious (I'm actually making a database to deal with quantitative financial information). I...