Hi.
I have a many-to-many relationship set up which seems to be working fine. I have now created a query that requests criteria from a form (See gif for relationship and query design).
The problem is that when i put in details for the first record the query works. however, for any other record it doesn't work. I'm not spelling things incorrectly and the data seems correct in the tables....
I hope this is a common problem when you first start designing queries!!! It's bugging me!!!
I have a many-to-many relationship set up which seems to be working fine. I have now created a query that requests criteria from a form (See gif for relationship and query design).
The problem is that when i put in details for the first record the query works. however, for any other record it doesn't work. I'm not spelling things incorrectly and the data seems correct in the tables....
I hope this is a common problem when you first start designing queries!!! It's bugging me!!!