Windows DataGridView
Table1: Terminal
Fields: TerminalID, TerminalName
Data: 1, DF
2, ADL
3, FG
Table2: Employee
Fields: EmpID,EmpName
Data: 1, Johan
2, Piet
Table3: EmpTerminal
Fields: EmpID, TerminalID, TimeAttendence, Access
Data: 1, 2, true, false
3, 2, false, false
On the form is all the details of an employee filtered by empID.
I would like to show a DataGridview with all the terminals. If a EmpTeminal exist for that employee I want to show the data in the grid view & if the employee does not have any terminals then I want to inter data to the EmpTerminal for that employee. A user can Activate or deactivate (TimeAttendence, Access) EmpTerminals for a specific employee.