>>>
>>>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.