Strange relationship in database

[jaryszek]

Hello Guys,



i have strange relationship between my tables (one to many):




tbl_reminders_employee looks like:



tbl_slow_spolki looks like:



How it is possible? My database is damaged here? Or what?

Example:

tbl_slow_spolki.ZleceniodawcaID = 10
For this record i should have attached wholde record with RemindersID = 2 in tbl_Reminders_employee (Joanna Arc employee) because its RemindersID_FK = 10...

Please help with explaining that.

In attachment please find the sample database.

Jacek Antek

[aytee111]

In table design view, show the property sheet. There are link fields - Link Child Fields and Link Master Fields. Set these to the correct values.

[jaryszek]

Thank you aytee111 ,

it is working ! you are the best !

Best wishes,
Jacek