Add Note fields to Datasets

January 11, 2013

We can’t typically can’t add note fields directly to any dataset. This is because you usually can have more than a single note for order or po and WebQuery requires a one to one relationship between tables. What we have done to get around this issue with several of our customers is to write a function that combines all of the notes into a single field. For example let’s say PO NO 123456 has two notes.
Instead of having 2 different individual PO Notes on two separate lines, You would have one PO Note field with all of the notes combined for each PO. PO Note 1: Note Information, PO Note 2: Note Information. If adding notes to your datasets is something you need let us know. We can typically add these fields in just a few minutes.