Search results

  1. E

    Query to Show Available Employee

    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...
  2. E

    Ms Access Relationship

    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...
  3. E

    Allocate multiple entries under same ID (team)

    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?
  4. E

    Autofill Form

    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 &...
Back
Top Bottom