Jump to content

Value List question


michaeldaly
 Share

This topic is 4402 days old. Please don't post here. Open a new topic instead.

Recommended Posts

My staff work to appointments and I am creating a database for these appointments. I have created a value list which contains the names of the staff members who are working during the hours of any given appointment but I would really like to be able to create a value list which narrows it down to those who are actually available - that is to say, those who are working and not already occupied in another appointment. I think I can get this result by writing a script, but is there a more straightforward way by creating a new relationship?

I've been struggling with this for months on end and would be eternally grateful for any input!

Thank you in advance,Michael

PS Sorry - I tried to attach my database but I'm apparently not permitted to upload that kind of file. I have attached a screenshot of the current relationship in the hope that it helps make things clearer.

Screen shot 2011-01-18 at 21.06.49.png

Link to comment
Share on other sites

Please explains what tables you have and what are the relationships between them.

I am also puzzled by the 'day' field in the Staff table. What exactly goes into this field? And what are shift_a and shift_b, time_a and time_b?

---

BTW, you can attach your file if you zip it first.

  • Like 1
Link to comment
Share on other sites

Please explains what tables you have and what are the relationships between them.

I am also puzzled by the 'day' field in the Staff table. What exactly goes into this field? And what are shift_a and shift_b, time_a and time_b?

---

BTW, you can attach your file if you zip it first.

Ahh, many apologies - I've now attached a zip file. There are two tables - "staff" and "appointments". The staff table contains the hours (or shift) worked by each person on any given day. In the appointments table, the time_a and time_b are the start and finish times of the appointments.

Thank you for looking, Michael

trial.fp7.zip

Link to comment
Share on other sites

This topic is 4402 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.