>>How about..
>>
>>Status.dbf
>>MemberID char(10)
>>Status varchar(20)
>>Status_Date date
>>Reason varchar(100)
>>
>>This way you can search/sort easily
>
>
>*laughing* ... Thanks William,
>
>Reason for laughing, my table highly resembles your structure where Reason = Memo and Status = listbox as the only difference.
>
>Much appreciative,
>
>Vernon
The difference is that VARCHAR fields do not require a memo file. No memo bloat or corruption.
Probably not a big deal if it is a small table.
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________