The more threads I read the more I get an understanding of how this thing works, there is still some grey areas though and hopefully I am getting closer to nailing this thing down, since I first posted I have realised some of my errors, so an update:
I want to make a database with all our staff contact details.
Our company has 6 departments and our staff has a 24hr and On Call rota,
I would like to make a simple UI so that each department could go in and select from a drop down list the staff who will be on overnight and on call.
Hopefully these selections will sit in place for quick access to phone numbers etc.
At first I thought it was forms and I made a nice looking form with selections etc but soon found out this was not the way to go.
I have attacched the database with this post, it is very small just a couple of names for test purposes but I think if you try the form you will see what I am trying to achieve in the long run.
Thanks
I want to make a database with all our staff contact details.
Our company has 6 departments and our staff has a 24hr and On Call rota,
I would like to make a simple UI so that each department could go in and select from a drop down list the staff who will be on overnight and on call.
Hopefully these selections will sit in place for quick access to phone numbers etc.
At first I thought it was forms and I made a nice looking form with selections etc but soon found out this was not the way to go.
I have attacched the database with this post, it is very small just a couple of names for test purposes but I think if you try the form you will see what I am trying to achieve in the long run.
Thanks