I Have 3 Tables Case Table, Forwarder Table, Orders Table
I Have Connected Them With 1 To Many Relationship.
1 Case Has Many Forwarders And Each Forwarder Many Orders.
I Tried To Make A Query Connecting For Start Case And Fowarders And Even I Start Writing Records In The Query's Case Fields I Can't Write In The Query's Forwarder Fields. Why Is That? And When I Manage To Write Says The Microsoft Search Engine Doesn't Find Any Maching Records Between The Two Tables.
Please Take A Look At My Database And Please Help Me.
I Have Connected Them With 1 To Many Relationship.
1 Case Has Many Forwarders And Each Forwarder Many Orders.
I Tried To Make A Query Connecting For Start Case And Fowarders And Even I Start Writing Records In The Query's Case Fields I Can't Write In The Query's Forwarder Fields. Why Is That? And When I Manage To Write Says The Microsoft Search Engine Doesn't Find Any Maching Records Between The Two Tables.
Please Take A Look At My Database And Please Help Me.