
Announcements
I have created two tables ,
Task Table with columns [Task Title(Primary Key) ,Task Description , Assigned To]
Worker Table with columns [ Name(Primary Key) , Number , Task ]
I have established Many to Many relationship between them and Task column LOOKUPS to Task Table
Now the issue is , when i enter multiple entries in Task Table with the 'Assigned To' set to XYZ
The Worker table only shows a single task
How should i tackle this such that worker table shows multiple tasks in the task column.