Memo to Small

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a access db that has a memo field for our clients treatments. We have
to log every clients treatment we give them in our massage therapy practice.

Is there an alternative to a memo field that i can use so we can store large
amounts of text. We have many clients that come in every week so there is
alot of information that must be logged. We need this because jsut in case
something may go wrong and then we have proof of what we preformed.

Thanks in advance
Lee
 
from Rainbow01 Hong Kong

1)suggest to use MSSQL server for back-end database if you need to store a
lot of data
2)use Access's ADP for front-end user interface

"Lee" 來函：
 
Lee,

Without knowing a little more, it is difficult to know exactly what the best
solution might be. However, with that said, this sounds like one of those one
to many situations.

Perhaps you might want to consider having a table of patients and another
table for visits of patients, with one of the fields being a memo type field
that could be used to describe the treatment for one specific visit. The two
tables would be linked by a Patient ID field. This would give you ability to
have over 65,000 characters for use in logging the treatment for each patient
during each visit.
 
Back
Top