Can there be sub tables in access

[lawdie]

Hi All,

I'm working on a college project, I'm building an IT helpdesk in access.
The problem I've encountered early on is,
StaffID is the staff number for employee.
StaffDep refers to the department the staff belongs to,

What I'm trying to generate is
If the StaffDep is IT then there StaffID is carried into a seperate table

This new IT Table will contain the StaffID (IT staff only) and some of the other tables data. Along with fields relating only for IT staff members.

If someone could put me on the right track I'd be grateful.

Many thanks, Lawdie

 

[Mudface]

You don't really need another table for that. A select query comprising of the StaffID, StaffDep (with a criteria of ="IT") and the other fields you require would suffice.

 

[lawdie]

Thank you for the guidance.
Sorry for the delay in reply.

Lawdie