Search results

Hi, I wish to create query where I can select the available employee for the period of job(engagement). For every engagement will form a team of multiple employees. I will select the employee and assign them into a team according to team ID. The tables related are as below: tblEngagement...

The system that I wish to create is a staff allocation. For every client, a team of employee will sent out for providing service which is call engagement. An employee will not be assigned into different team under same time.

I have remove the employeeID from team table. For the task part, what I want is after I allocate employee into a team and then assigned tasks for the team member. So should I linked the task table with team-employee table? Please advice. Thank you so much!

I have built several tables for my database which includes the employee, client, engagement, team and task table. I found that my tables contain a many to many relationship so I created a table to link the both tables. Please advise if the relationship have any problem. 1 client will have...

But I not sure how to add the multiple employees into a same team in a form. As when I use a button to save the updates, it shows that duplication of team ID while I was actually expecting multiple employee ID(s) to be added into the team ID

I want to allocate multiple employees into a team. How can I do that? I got employee table consist of: ID, Full Name, Address. Team table's main function is to allocate the employees under the same team ID. Is that possible?

Hi! I wish to make an autofill forms where I select the value from the combo box the rest of the textbox will showed the related data. Is it possible for me to link the data from two different tables? For example: Select Client ID will autofill the client name and its type from Client Details &...