Well, whatever works for you, I always say. <g>


>This is all C/S style so think of 2 paragraphs at best for notes in a VFP memo field. I have taken them line by line into SQL Server. Text is the column type and they are only at worst 500 chars long. That would be 1 or 2 that size line along with 6+ that only have < 100 chars.
>
>I don't think that I'm killing myself with this. Usage might only be 5 times a day by 2 people.
>
>__Stephen
>
>>Hmmmm, well maybe easier, but possibly a lot of overhead (size of the DataSet) if you have a lot of notes?
>>
>>
>>>What i did was to Union both into the same DataSet and have the code in the print button remove the lines they checked. Thought about it over lunch as an easier way, and
>>>
>>>
>>>>Stephen,
>>>>
>>>>There's a method for Tables, called ImportRow() that will do what you want to do.
>>>>
>>>>~~Bonnie
>>>>
>>>>
>>>>>I have a ds with 2 tables for reporting. They are notes, in house and outbound. In some cases we want to share some inside notes with a customer. I have the datagrid to display the in-house notes, and the user checks a check box to reference what they want to copy/append to the bottom of the outbound table.
>>>>>
>>>>>I have only 2 columns no_memo and no_line. Line is the sorting for outbound selection. Memo is the meat from an old VFP system.
>>>>>
>>>>>How would you move the data within the ds?
>>>>>
>>>>>TIA
>>>>>
>>>>>__Stephen