Daily document tracking

[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 ?

 

[Keith Wilby]

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 ?

Why would you want to? Tables are buckets to contain data and should not be
used for viewing or processing data. That is what queries and forms are
for. As for the "+", this is a mis-feature that should be turned off by
disabling "Name AutoCorrect" and setting the tables' sub-datasheet property
to None.

Keith.
www.keithwilby.co.uk

 

[Kutty]

Where is this "Name AutoCorrect" staying in?
Where to set the tables' sub-datasheet property to None ?

I went to Form tab and have done as follows :
- clicked new
- clicked form wizard
- chose Table1, clicked OK
- selected and clicked ID and STAFF_NAME field
- Clicked Next
- Clicked columnar
- clicked Next
- Nows shows a window "No current record"
So I can't create main form and subform.

 

[Keith Wilby]

Comments in line ...

Where is this "Name AutoCorrect" staying in?

Tools, Options, General tab.

Where to set the tables' sub-datasheet property to None ?

In design mode, show the Properties palette. It's 7th on the list (Access
2003).

I went to Form tab and have done as follows :
- clicked new
- clicked form wizard
- chose Table1, clicked OK
- selected and clicked ID and STAFF_NAME field
- Clicked Next
- Clicked columnar
- clicked Next
- Nows shows a window "No current record"
So I can't create main form and subform.

Don't use the wizard. Create a new form in design view and bind it to your
main table. Include what fields you need and save the form. Now create
another form and bind it to your child table (or "many" table). Include
what fields you need and save the form. This is your sub-form. Close the
sub form.

With your main form in design view, split the window so that you can see the
form and the db window. Drag the sub-form onto the main form. Save the
main form.

You now need to tell the main form how it relates to your sub form. In
design view, show the properties palette. Select the data tab. Click in
the Link Child Fields area and then click on the "..." button. Select your
Primary and Foreign Key fields to create the relationship. Job done.

Keith.
www.keithwilby.co.uk

 

[Kutty]

I could not see "name auto correct" in MSAccess 2007 version. I went to
tools, option, general.
Please comment.