Database

[Kutty]

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 ?

 

[Jeff Boyce]

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]

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]

Kutty

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

Regards

Jeff Boyce
Microsoft Office/Access MVP