Event Journal

[LossManiac]

New to access design issues I need to design a database where I can a) record
events (with a free format text box) that have occurred with respect to the
various cases that we investigate.

Each case will have a job number, Name and Case typ. I need to record the
history of an event against each case. I also need to categorise the event
for reporting purposes.

I would like to be able to enter only the job number into a form with the
name and case type being called up into the form automatically.

The Access Contact management template appears to provide a basis for the
input form design (using the link forms concept).

Thanks for any help.

 

[Piet Linden]

Main Form:
Case(JobNumber, CaseName, CaseType)

Subform:
EventHistory(EventID, CaseJobNumber, EventType, EventDescription)

join on Case.JobNumber=EventHistory.CaseJobNumber

Include a memo field in your EventHistory table where you can enter
your notes about the event.

 

[LossManiac]

Dear Piet,

Thanks for your help. What I would also like to do is to have the CaseName
and CaseType generated into the form via a lookup function link to the
JobNumber in order to maintain name and type integrety and to speed up
inputing.

The table containing JobNumber, CaseName and CaseType has already been built
and populated.

Regards