Hi! I have two tables: Clients and Jobs. I am trying to work with a list box within the table Jobs. The list comes from the other table, Clients.
The problem is that sometimes I just don't get to make a query that shows just one of the clients. That is, I have Client1, Client2, Client3 etc. I have a field also named Client in the other table (Jobs). It works to insert records into the table Jobs, but when I try a query, sometimes it works, but many times it doesn't.
For instance: I want a query showing all the records of Client 3 and I know Client3 is present at the table Jobs, but the query doesn't show anything.
What in the world am I doing wrong? This is driving me crazy!!! What are the details I must observe carefully so I can get a query out of a table with a list box? Thanks!