Document Tracking

[Kutty]

Table1
ID_NO Primary key
EMPL_NAME


Table2
ID_NO Foreign key
TRACK_NO
DOCUMENT_NAME
PROCESS_NAME
DATE_FORWARDEDTO

TRACK_NO is Auto Number

I have 2 tables to maintain data base of daily tracking of documents which
is forwarding to different department after signature of my boss. Whenever I
want to track the documents which I forwarded I find out from the physical
file I have to search data base. Each physical file I made by employees
name. Whenever I enter new record in table 2 I need new record by producing
new Auto number in TRACK_NO field.

Would appreciate your great favor. How to do this?

 

[karl dewey]

Create a one-to-many relationship between Table1 and Table2 on ID_NO. Set
Referential Integerity and Cascade Updates.
Use form/subform for Employee/Track_No with Master/Child link set on ID_NO.
Use a combo box to select the Employee.

 

[Kutty]

Please explain the below two line :
Use form/subform for Employee/Track_No with Master/Child link set on ID_NO.
Use a combo box to select the Employee.
What you mean by use form/subform for Employee/Track_No? I have confusion.

 

[Kutty]

Do you mean set Master/Child link with Track_No with ID_No ?

 

[Douglas J. Steele]

No, Karl means that you'd have ID_NO as both the Master and Child Link Field
values.

The form being used as the parent would be bound to Table 1, and the form
being used as a subform would be bound to Table 2. You need to link via
ID_NO so that the subform only shows those records that correspond to what's
being displayed on the parent form.