relation between date table and date column

[Mahmoud_nabir]

i have created date table and make relation between it and HH_VISIT table with (starttime) column but any selection in the date doesn't reflect on the VISIT table.

i tried relation with invoice table it work normaly but i don't know why it doesn't work with HH_VISIT table.

[Mahmoud_nabir · Accepted solution]

Solved 

i have created column format date and make the relation with that colmn and it worked normaly.