Setup Table for Information query form

[kurt114]

Hi,

I'm new to Access. I want to setup a small database for work which manage records of information request.

For example I have department A, B and C. Information request form consists of a requester and responder. Either department (A,B or C) can be responder or requester.

My current setup is a table call tblRequest that includes all the fields for the information request, and a table call tblDept includes the department (A,B,C)

Should I link the table and how? or just use tblDept as a list for responder/requester?

 

[arnelgp]

should there be any Status of the request?
more or less you will need:

tblStatus
ID                          autonumber
Status                    short text

tblDepartment
ID                           autonumber
Department             short text

tblRequestHeader
ID                            autonumber
RequestDate             date/time
StatusID                   number, long                  ID from status table
RequesterID              number, long                  ID from department table
ResponderID             number, long                  ID from department table

tblRequestDetail
RequestID                number, long                   ID from request header
Details                     short/long text

link tblRequestHeader to tblDepartment by RequesterID (left join)
link tblRequestHeader to tblDepartment by ReponderID (left join) (new link)
link tblRequestDetail to tblRequestHeader by RequestID (left join)
link tblRequestHeader to tblStatus by StatusID (left join)

 

[theDBguy]

Hi Kurt. Welcome to AWF!

 

[kurt114]

Thank you very much for your advice. I feel very welcomed