Afternoon all,
Before I start I must point out that I'm a relative beginner.
I've been asked to set up (what seemed) a fairly basic database which would allow helpdesk operators to identify sites and on call staff related to them.
Staff are grouped into three categories and related to different sites according to which rota they belong to (the rota for staff and sites doesn't change).
This I could cope with, but only one of the staff related to each site will be on call at any one time.
What I'm aiming to do is to have a form with a combo box listing all the sites. When a site is selected either the on call staff from the three categories are shown in text boxes, or, a button is pressed taking the user to a seperate page with the on call staff displayed.
At present I have the following tables:
Site
Staff1
Staff2
Staff3
and three link tables between Site and the Staff tables.
The fields are fairly standard for all tables i.e. ID#, Name, TelNo etc and I have a OnCall field for the Staff tables with a Yes/No data type.
I just can't get the required info to be displayed.
Any help would be much appreciated (even if it is pointing out how stupid I am!)
Many Thanks,
bumpydog
Before I start I must point out that I'm a relative beginner.
I've been asked to set up (what seemed) a fairly basic database which would allow helpdesk operators to identify sites and on call staff related to them.
Staff are grouped into three categories and related to different sites according to which rota they belong to (the rota for staff and sites doesn't change).
This I could cope with, but only one of the staff related to each site will be on call at any one time.
What I'm aiming to do is to have a form with a combo box listing all the sites. When a site is selected either the on call staff from the three categories are shown in text boxes, or, a button is pressed taking the user to a seperate page with the on call staff displayed.
At present I have the following tables:
Site
Staff1
Staff2
Staff3
and three link tables between Site and the Staff tables.
The fields are fairly standard for all tables i.e. ID#, Name, TelNo etc and I have a OnCall field for the Staff tables with a Yes/No data type.
I just can't get the required info to be displayed.
Any help would be much appreciated (even if it is pointing out how stupid I am!)
Many Thanks,
bumpydog