form or query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello

I am woking with a three tables ,, the main table contain the field (
Item_no , Itme_name , and balancd) , the second table is for issue material
and contain (bill_no , date , item_no ) and the last table for recieving
material and contain the same field of table 2 , what I need is to update the
balance in table 1 in every input in tables 2 and 3 in a form for issue and
recive as follow

main table
itme_no item_name balance
1 XXXXX 100
2 YYYYY 120

issue table
item_no bill date qty
1 28 12/09/05 42
2 29 15/09/05 22

recieve table
item_no bill date qty
1 28 12/09/05 66
2 29 15/09/05 77

also I need to prompt for the name of item in each form (issue & recieve)

Thanks in advance
 
Hi Emad,

Check out MVP Allen Browne's sample here:

Inventory Control: Quantity on Hand
http://allenbrowne.com/AppInventory.html

Also, note that "Date" is a reserved word. You should avoid using reserved
word in Access for anything that you assign a name to.

Reserved Words in Microsoft Access
http://support.microsoft.com/?id=286335

List of reserved words in Jet 4.0
http://support.microsoft.com/?id=321266


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

hello

I am woking with a three tables, the main table contain the field (Item_no,
Item_name, and balance), the second table is for issue material
and contain (bill_no, date, item_no) and the last table for recieving
material and contain the same field of table 2, what I need is to update the
balance in table 1 in every input in tables 2 and 3 in a form for issue and
receive as follow

main table
itme_no item_name balance
1 XXXXX 100
2 YYYYY 120

issue table
item_no bill date qty
1 28 12/09/05 42
2 29 15/09/05 22

recieve table
item_no bill date qty
1 28 12/09/05 66
2 29 15/09/05 77

also I need to prompt for the name of item in each form (issue & recieve)

Thanks in advance
 
Back
Top