If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Event Journal
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. |
#2
|
|||
|
|||
Event Journal
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. |
#3
|
|||
|
|||
Event Journal
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 "Piet Linden" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|