So we now have a (potentially) many-to-many relationship between sales orders and purchase orders.
In practice, one sales order may have multiple purchase orders, or one purchase order may have multiple sales orders.
We're happily storing these as text in a Notes field on the respective screens, and that's working fine, and I can add notes either programmatically, or by just typing the corresponding OrderNo in the notes field.
So the question is: can I add a 'lookup' button column to the notes grid? It's not desperately needed, but it would be kinda cool if when a user picks a note type of "Related Purchase Order", I could enable a lookup button that fires off a Purchase Order Search.