Hi all,
I have a problem with a query. There are two tables, first with complete guest data and second with logs of his activity. Tables are conected via guest ID. I have a query that pulls data from both tables with the guest ID as a query criteria (ID is pulled from the second table via dropbox, so it's 100% correct). The only problem is that for some guests it works and for the others it just doesn't. I also noticed that for those guests the query doesn't work there is no data when I press the + sign for the record in my main table, even if that guest exists in the second table. I included the picture of the tables. For Grazzi the query works, for Grbac it doesn't. Do you have any idea why? I'm lost and also sure that it is something trivial :-).
Regards, Samo