MSACCESS - SUB FORM

[Kutty]

I have designed a program in msaccess about file tracking for my office.
Table_1 : EMPLOYEE ID --------------------------NUMBER
EMPLOYEE NAME----------------------TEXT

TABLE_2 : EMPLOYEE ID----------------------- NUMBER

DOCUMENT TRACK# AUTONUMBER
EMPLOYEE DOCUMENT SERIAL#----TEXT
TYPE OF DOCUMENT-----------------TEXT
FORWARDED TO ---------------------TEXT
FORWARDED DATE-------------------DATE/TIME
NOTE---------------------------------- MEMO
PRIMARY KEYS: EMPLOYEE ID, DOCUMENT TRACK#
Table 1 is main form, Table 2 is subform. In Main form I need 4 buttons.
That is : DUTY TRAVEL, EXIT RE-ENTRY REQUEST, REQUEST FOR GOODS, VACATION
REQUEST. Once I press the button I have to get a new form. The
database under every buttons out of 4 buttons will be different. Please
tell me
how can I design this four different windows to get once I press each button.
Would appreciate your great favor.

 

[Vincent Johns]

It's not clear to me exactly what you want to show. Your 2 tables seem set
up to track documents and relate them to employees who I assume are
responsible for writing or approving them, and then forwarding them on to
someone else. The 4 buttons you mentioned,
- DUTY TRAVEL
- EXIT RE-ENTRY REQUEST
- REQUEST FOR GOODS
- VACATION REQUEST
, seem to relate to the type of document in "TABLE_2". Is this true? If
so, I suggest adding a field to TABLE_2 that identifies the document. Also,
more suggestive names for your tables wouldn't hurt, for example "Employee"
instead of "Table_1".

If I'm correct, once you've added a field that identifies document types,
you can apply a filter for each of the buttons that will display only the
documents of the desired type. You might want to use the Switchboard Manager
to save time & effort setting up the buttons, each of which could display a
different Form.