Hi,
My sub-form is not displaying relevant record as per header form. What would have gone wrong?
Both tbls are on SQL Server and linked in my Access db. Headform has no issue it is bringing the desired record as selected in Combo but the relevant record is not displying in sub form.
1. Linked fields are OTID, EMPNUM and OTDate
2. Main tble has primary key on OTID where as footer tble has same field with no primary key set.
3. While placing sub form in main form, I have linked them with 2 more field other than OTID. Those are EmpNum and OTDATE.
Now my subform is not reading the relevant data. I even deleted old records and add new and then recalled by choosing record from main form combo but still same.
Can anyone help me please...
My sub-form is not displaying relevant record as per header form. What would have gone wrong?
Both tbls are on SQL Server and linked in my Access db. Headform has no issue it is bringing the desired record as selected in Combo but the relevant record is not displying in sub form.
1. Linked fields are OTID, EMPNUM and OTDate
2. Main tble has primary key on OTID where as footer tble has same field with no primary key set.
3. While placing sub form in main form, I have linked them with 2 more field other than OTID. Those are EmpNum and OTDATE.
Now my subform is not reading the relevant data. I even deleted old records and add new and then recalled by choosing record from main form combo but still same.
Can anyone help me please...