What is the best practice for dealing with many input forms that
contain memo fields
to capture exceptions and extra information ( an audit trail or updates
field would be
one example) needed as an item moves through different processes. Note,
there are
some tables in which I have simply added a text field set to 255,
however, some of
these tables will have many edits and updates.
I thought about setting up some tables like this:
( tblMemos )
MemoID (Autonumber) 1-------( One Side)-----
Memo (Memo)
( tblItems )
ItemID
ItemDesc
MemoID >------(- to - Many Side )-----
well this is a fairly simplified version but you get the point...
right?
I also thought that this might hurt performance but that's a relative
statement
...and this may be a NULL issue given the power of modern PCs,
processors, and
network capacity (10/100/1000 cards, routers, and switches).
....or maybe I'm wrong?