Happy New Year Everyone!
I am pretty new to MS Access as I have not had to use it since 2006!
I have the tables set up but need to create a form which is able to search multiple tables. The idea behind my database is to have a form which can search peoples skills. The database will contain records of individuals and the skills they hold. E.G I want users to be able to search Phone and then everyone with phone skills appears. I also have other things I want people to be able to search for. Please see below the names of my tables and the fields below. If someone could help me it would be greatly appreciated:
COULD SOMEONE ALSO HELP ME OUT WITH THE RELATIONSHIPS TOO PLEASE??
Staff Table:
Staff ID
Title
First Name
Surname
Tel
Email
Location ID
Location Table:
Location ID
Location Descriptor
Skills Table:
Skill ID
Skill Descriptor
Theme Table:
Theme ID
Theme Descriptor
Junction Theme Staff Table:
Staff ID
Theme ID
Junction Staff Skills Table:
Staff ID
Skills ID
I am pretty new to MS Access as I have not had to use it since 2006!
I have the tables set up but need to create a form which is able to search multiple tables. The idea behind my database is to have a form which can search peoples skills. The database will contain records of individuals and the skills they hold. E.G I want users to be able to search Phone and then everyone with phone skills appears. I also have other things I want people to be able to search for. Please see below the names of my tables and the fields below. If someone could help me it would be greatly appreciated:
COULD SOMEONE ALSO HELP ME OUT WITH THE RELATIONSHIPS TOO PLEASE??
Staff Table:
Staff ID
Title
First Name
Surname
Tel
Location ID
Location Table:
Location ID
Location Descriptor
Skills Table:
Skill ID
Skill Descriptor
Theme Table:
Theme ID
Theme Descriptor
Junction Theme Staff Table:
Staff ID
Theme ID
Junction Staff Skills Table:
Staff ID
Skills ID
