>>>>
>>>>Our idea was simpler. We just wanted to move Memo fields out of our Trans table and have something with Trans_Memo table with one to one relationship with Trans table (actually we may have less records in Trans_Memo table).
>>>>
>>>>But I just realized it would not help much in terms of space limit reaching. It would help in terms of speeding up operations of saving, retriving data.
>>>
>>>
>>>I don't see how it'll speed up saving or retriving .
>>
>>You're not retriving Memo field until you really go to the Notes page.
>
>You would get the same result if you don't include a memo field in the select.
Right.
If it's not broken, fix it until it is.
My Blog