How can i fix this?
|11/25/2023 3:19:16 AM
|PHPRunner General questions
Hello everyone. I am working on building a program for preparing a schedule. The program administrator can schedule a date for a group of visitors with this program. Each visiting group needs a guide (or several) to give a tour. Each guide can enter a date in the program if he/she is unable to give a tour on a chosen date.
create a custom view with Usertable and Absence table. The SQL script is
This you wrote "The manager can then select a guide who is NOT available on the chosen date" confuses my but if you want all guides that not entered a date to absence table then in the field you need the list use the lookup wizard, as table select the above custom view link and display field name for insance and in WHERE write this
|I author 11/26/2023
Thanks for this helpful tip while I was running a query with this code. Works well. Thank you