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