Go Back   Computer Forums > General Computing > Software and Operating Systems
Click Here to Login
Join Computer forums Today


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 11-24-2011, 06:03 AM   #1
Beta Member
 
Join Date: Nov 2011
Posts: 5
Exclamation Query In Access 2007

I am new to access... so i need your help designing a query...
I have made two tables , namely Shoe Order Table And Shoe Stock Table...
now what I want to do is , if I enter a value to a field (qty. demanded , to be precise) in Shoe Order Table.... The value automatically is added to a field (qty left) in the Shoe Stock Table...
.................................................. .................................................. .............
Plz use simple techniques as I am just an o-levels student :-)
Reply Quickly....
__________________

hamxa7 is offline   Reply With Quote
Old 11-24-2011, 06:10 AM   #2
Fully Optimized
 
ssc456's Avatar
 
Join Date: Jan 2007
Posts: 4,279
Send a message via MSN to ssc456
Default Re: Query In Access 2007

I've never been a big fan of access so i'm not sure on the exact way of doing this. But what you need to look into is Databse triggers and stored procedure.

What you will be doing here is creating a stored procedure which is in affect a stored query which is triggered upon update of your first table.
__________________

__________________
He who has never failed has never attempted anything worth succeeding at.

Dont Eat Animals, Its Not Good For Them And They Dont Like It!
ssc456 is offline   Reply With Quote
Old 11-24-2011, 08:52 PM   #3
Beta Member
 
Join Date: Nov 2011
Posts: 5
Exclamation Re: Query In Access 2007

Thnx for your answer but I need a full step by step explanation on how to do this....!!!
hamxa7 is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



All times are GMT -5. The time now is 02:18 PM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0