Document Tracking

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?

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.
--
KARL DEWEY
Build a little - Test a little


"Kutty" wrote:

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?

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.

"karl dewey" wrote:

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.
--
KARL DEWEY
Build a little - Test a little


"Kutty" wrote:

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?

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

"Kutty" wrote:

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.

"karl dewey" wrote:

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.
--
KARL DEWEY
Build a little - Test a little


"Kutty" wrote:

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?

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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Kutty" wrote in message
...
Do you mean set Master/Child link with Track_No with ID_No ?

"Kutty" wrote:

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.

"karl dewey" wrote:

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.
--
KARL DEWEY
Build a little - Test a little


"Kutty" wrote:

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?