building a fairly simple database to serve as a shift log. date/time/initials/event details/follow up required check box all make up the table (and a primary key autonumber field)
what I want is to be able to run a report for those things that need follow up - simple.
then I want to be able to capture secondary information on the follow up - another set of date time initials and event details -
should that be another table? Or in the same table?
I took a shot at setting it up in the same table but when I tried to make a form that featured the original entries and the secondary entries it got so crowded that the text boxes required scrolling and it just didn't allow comprehension.
I tried to find a way to have the text fields autosize but couldn't find something I was smart enough to implement.
really appreciate any help on A) how to structure but mostly B) how to set up a form such that a person could have two potentially long memo fields (one from the first event and one for the subsequent follow up) that either autosized or maybe with a button that could at least open up that field in a broader view so you could read or type a coherent description of the event.