Database

In my office I am processing each daily incoming document and forwarding to
the concerned department. I need to make database to track it as follows :

Table 1 fields : ID#, STAFF_NAME
Table 2 fields : ID#, TRACK#, DATE_RECEIVED, DOCUMENT_NAME, FORWARDED_TO

Relationship : one to many
Primary key : ID# in Table 1
Foreign key : ID# in Table 2
TRACK# : Autonumber

After connect Table 1 to Table 2 I cannot see +sign in each record of
Table 1. Why ?

If you "cannot see the + sign ... in Table 1", you are working directly in
the tables. Bad idea!

Access tables store data, Access forms display it.

After you get the tables defined and the relationships among the tables
established, use the forms, Luke!

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Kutty" wrote in message
...
In my office I am processing each daily incoming document and forwarding
to
the concerned department. I need to make database to track it as follows
:

Table 1 fields : ID#, STAFF_NAME
Table 2 fields : ID#, TRACK#, DATE_RECEIVED, DOCUMENT_NAME,
FORWARDED_TO

Relationship : one to many
Primary key : ID# in Table 1
Foreign key : ID# in Table 2
TRACK# : Autonumber

After connect Table 1 to Table 2 I cannot see +sign in each record of
Table 1. Why ?

This question is for my knowledge:
Can I see + sign in primary key table in msaccess version 2007 ?
I can see + sign in version 2003.



"Jeff Boyce" wrote:

If you "cannot see the + sign ... in Table 1", you are working directly in
the tables. Bad idea!

Access tables store data, Access forms display it.

After you get the tables defined and the relationships among the tables
established, use the forms, Luke!

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Kutty" wrote in message
...
In my office I am processing each daily incoming document and forwarding
to
the concerned department. I need to make database to track it as follows
:

Table 1 fields : ID#, STAFF_NAME
Table 2 fields : ID#, TRACK#, DATE_RECEIVED, DOCUMENT_NAME,
FORWARDED_TO

Relationship : one to many
Primary key : ID# in Table 1
Foreign key : ID# in Table 2
TRACK# : Autonumber

After connect Table 1 to Table 2 I cannot see +sign in each record of
Table 1. Why ?

Kutty

No experience there. Have you tried searching with your favorite on-line
search site?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Kutty" wrote in message
...
This question is for my knowledge:
Can I see + sign in primary key table in msaccess version 2007 ?
I can see + sign in version 2003.



"Jeff Boyce" wrote:

If you "cannot see the + sign ... in Table 1", you are working directly
in
the tables. Bad idea!

Access tables store data, Access forms display it.

After you get the tables defined and the relationships among the tables
established, use the forms, Luke!

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Kutty" wrote in message
...
In my office I am processing each daily incoming document and
forwarding
to
the concerned department. I need to make database to track it as
follows
:

Table 1 fields : ID#, STAFF_NAME
Table 2 fields : ID#, TRACK#, DATE_RECEIVED, DOCUMENT_NAME,
FORWARDED_TO

Relationship : one to many
Primary key : ID# in Table 1
Foreign key : ID# in Table 2
TRACK# : Autonumber

After connect Table 1 to Table 2 I cannot see +sign in each record of
Table 1. Why ?