Hi everyone
hope you can help I've set a query to return data back from a form so i can report on it.
I've done some test data and i am only getting two MainID showing data, any of the other test data does not return data.
I have checked the table and the data for all of the mainID test data is there ok, even when i look on the form, the test data is there fine.
but will not pull through the qry?? i think i may have a relationship wrong but . meh unsure. lol
I've included some screenshots.
hope you can shed some light, thanks for any help
all the best baxton