Update Master Table from RECT or ISSUE

[shyamsundar]

Hi Tech guys,

I am used to foxpro for dos and recently switched to Access 2000 and find to be very good.

Now I need some help on the following

I have the following tables
Item table- it_code
it_name
it_balance

Rect table -Rect_no
Rect_no
Supplier

Rect_item Table(linked to Rect table for Rect_no)
-Rect_no
-It_code
-It_qty

Now, I want to add the qty to item table, when ever i received the item. And, I want to minus it whenever I issue, I also want to check the Qty available in Item table for the particular item before i issue. I understood this can be done thru sql, but i normally do in the foxpro with seek commands

like....seek item_code
if .not. eof().and. it_qty <=issue_qty
replace it_qty with it_qty - issue_qty
endif

Pl. help me how to do it in ACCESS.

Thanx

Shyam