Thanks for the clarification and I'm with Barry. Do not do this as it is asking for issues.

If this were an extremely busy system and the were performance problems from the join, I might think this is OK, but you'd also have to note in the master record if there is more than one detail row, because then you'd have to do the join.

Index on masterID, fieldA, fieldB and this will cover and join quickly.