title: MS Access - How to Increment number in a different table?
body: <p>I am very new to MS Access and my question is that if I have two tables and Table1 have 10 entries and that table have a drop down list of yes and no and a name field(multiple entries with the same name). Now in Table2 there is a Name field(no multiple entries) and total field. So whenever user select "yes"from that drop down menu from Table1 then the total field in my Table2 should get increase by 1.So is it possible to do it this way or is there any other and simple way to tackle this problem? Thanks in advance.</p>