Form on many to many relationship

[jaryszek]

Hi People,

i have relationships like that:





It is okey but problem is with achieving what my client wants.

Creating query i have:



My client wants to get whole table tbl_Reminders_employee with all rows and possibility to add companies there.

My query is working as inner join so i am getting only 3 rows because in my NamesRemEmployee table there is only 3 matching rows:



It is possible to create form with tbl_Reminders_employee all rows and give users possibility to add new companes within datasheet view?

Please help,
Best Wishes,
Jacek Antek

[jaryszek]

Okey i did this:



i had to change my relationship within the query from one to many and I did twice left joins between tables.

Best Wishes,
Jacek