Hi Guys,
I have 2 tables:
In tbl_Braki there is ID as Primary Key and autonumber.
Problem is that field "Nr_zgłoszenia" can be duplicated like here:
Now i would like to create relationships between tbl_Braki and Przypominacze table.
So as you can see it is done like one-to-many relationships.
Now for each ID there is an treeview (node) which can be expand.
I am thinking it is possible to do this small plus icon next to Nr_zgłoszenia field?
for example for ID 1,2,3,4 and 5 it is only one employee attached with number 1. And for this employee i would like to add the same date of sending reminder.
So, ID 1 and Nr_zgłoszenia 1 date of sending will be 01-01-2017
ID 2, 1, 01-01-2017
ID 3, 1, 01-01-2017
ID 4, 1, 01-01-2017
ID 5, 1, 01-01-2017
I do not want to write the date 5 times, only one time and attach it to my Nr_złoszenia field.
How can i relate this?
Thank you for help,
Jacek Antek