>Greetings!
>
>Undecided on which to use. I've an application (quite simple) where I need to maintain member status history (i.e. Active, Suspended, Reinstated, Deceased, etc.). When the member status change, I need to record the date and reason. Would it be wise to use a Memo (appending info everytime there's a change in status) or use a table (adding new records)? Since I rarely use memo type fields, are they often prone to corruption?
>
>TIA,
>
>Vernon
How about..
Status.dbf
MemberID char(10)
Status varchar(20)
Status_Date date
Reason varchar(100)
This way you can search/sort easily
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________