i have 2 tables
first table :
1- name
2- position
3-nationality
4-visa No.
second table :
1-position
2- No of visas .
3- No of used visas .
4- No of remaining visas .
I want to use iif function(access) when add new position in first table increases the no of used visas in the second table automatically
pls help me