Design Question

[Guest]

I am designing a form that will have the person's signon and the current date
autopopulated. I have that down. My question is two-fold. One, the
operator is required to enter comments whenever they touch any record.
Management wants the comment prefaced with the date / time / signon. I was
wondering instead of making a totally new table and having to do the sub-form
routine, would it be possible to put all the prefaced information in the
comments, have the operator enter their comments and when another person has
to go in on the same record, append the new date / time / signon and new
comments to the same field without having the new data overlay the old.

Thanks

 

[Pieter Wijnen]

You're on the right track
Keep the date (w time) & sigon as seperate fields
then use a query to "merge" this with the actual comments to appease
management
you would need a seperate table to hold the different operators (timed)
comments anyway.
A very rough approach would be to use a subform with AllowEdits=No &
AllowAdditions=True

HTH

Pieter