Maybe it just makes more sense for Annotation / Comments to be a new TextField on OrderItem, defaulting to u""?  Then this extra lookup can happen cart insertion time, but the reporting will just select from one table.