>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
Hi Vernon,
If you need to manipulate this information later, then new table would be a better choice. If this is going to be for display purpose only, then memo field is sufficient. You can actually do both and that's what I think we were using in our case for similar requirements.
If it's not broken, fix it until it is.
My Blog