Joining tables in Update page for Databridge
I'm starting a new project and trying to think through how to get it done properly.
Client has several employees who perform timed tasks, ie, at 8 am, they sign into work, by 9 am a set of tasks need to be completed, etc.
I know at some point I'll need to revisit Security Assist for individual employee login, but I'm not that far along in my work yet. I used SA a few years ago for a membership site, so I'll need to dust off my notes to learn how to do it again.
So at this stage, I have created these tables:
Projects (project_ID, project_name)
Tasks (task_ID, task_name, task_starttime, project_ID, employee_ID, task_competion -using a timedate stamp)
Employees (employee_ID, employee_name, employee_email, employee_password)
So, the employer will create the Project, assign tasks to that project, and an employee.
What I need then, is an employee Update page that will present fields so a particular employee can check a box when a task is completed. So that Update page will need to join all three tables together. I know how to create the page that presents three tables for the employer, but not yet sure how to make the update page for the employee. Can more than one table be used in an Update page? Any tutorials for doing this?
Thanks to anyone who has time to read and respond.