SQL join

[rafirasyidi]

Hi

I have question regarding to query on Microsoft Access. Currently I'm developing a database and I'm trying to use left join query on form. In this event I'm going to use as reservation. However, the query works but not 100% because when I hit a reserve button it is carrying some fields (Catalogue no and game title) but when I'm trying to do it with different game title and cat no, it is always keep the old record. What I want to do is every time I'm hitting different games the field that should run is similar to the game that I want to reserve.

I appreciate any advices

Thanks

Rafi

 

[llkhoutx]

Queries run perfectly if constructed correctly. Improper joins or improper filters create unwanted and unexpected results.