By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,486 Members | 1,764 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,486 IT Pros & Developers. It's quick & easy.

updating records within another table

P: 49
Hello All, Another problem!!!!!

Currently i have a product table and an order table, when a customer places an order, the quantity in the product table should update and so if the same item was to be selected again the quantity level should minus from the previous order that was placed.... What would i need to tell it to update the quantity in the product table?
Jan 26 '08 #1
Share this Question
Share on Google+
7 Replies


ADezii
Expert 5K+
P: 8,679
Hello All, Another problem!!!!!

Currently i have a product table and an order table, when a customer places an order, the quantity in the product table should update and so if the same item was to be selected again the quantity level should minus from the previous order that was placed.... What would i need to tell it to update the quantity in the product table?
  1. What is the name of the Product Table?
  2. What is the name of the Order Table?
  3. Is there a Total Quantity Field for each Product? If so what is its name?
  4. What is the name of the Quantity Field in the Order Table?
  5. Is there a 1 to MANY Relationship between Products and Orders? If there is, what is the name of the Linking Field? (There is usually a MANY to MANY relationship between Products and Orders but we'll forget that for now).
  6. What is the name of your Form where the Order info is being entered? Is it a Sub-Form?
  7. What is the name of the Quantity Field on the Order Form/Sub-Form?
  8. I think you get the idea by now...
Jan 26 '08 #2

P: 49
  1. What is the name of the Product Table?
  2. What is the name of the Order Table?
  3. Is there a Total Quantity Field for each Product? If so what is its name?
  4. What is the name of the Quantity Field in the Order Table?
  5. Is there a 1 to MANY Relationship between Products and Orders? If there is, what is the name of the Linking Field? (There is usually a MANY to MANY relationship between Products and Orders but we'll forget that for now).
  6. What is the name of your Form where the Order info is being entered? Is it a Sub-Form?
  7. What is the name of the Quantity Field on the Order Form/Sub-Form?
  8. I think you get the idea by now...
Name of product table = tblproduct
Order table = tblorder
total quantity field = Quantity
Quantity field in order table = well i have the current stock which represents the total within the product table, which is called stock1, and then quantity1 which is the amount which they order and then i added a newquantity within the order table which represents the stock - quanity and the newquantity should be updated within the product table.
frmorderform is where the info is being entered
in the order form i have a field called txtstock1, which is the record from the product table, then cboquantity1, this is where u select the quantity which is requried.
Jan 26 '08 #3

ADezii
Expert 5K+
P: 8,679
Name of product table = tblproduct
Order table = tblorder
total quantity field = Quantity
Quantity field in order table = well i have the current stock which represents the total within the product table, which is called stock1, and then quantity1 which is the amount which they order and then i added a newquantity within the order table which represents the stock - quanity and the newquantity should be updated within the product table.
frmorderform is where the info is being entered
in the order form i have a field called txtstock1, which is the record from the product table, then cboquantity1, this is where u select the quantity which is requried.
If you like, how about sending me the Database as an E-Mail Attachment, and I'll look at it as soon as possible, If this is agreeable to you, please let me know and I'll send my E-Mail address to you as a Private Message.
Jan 26 '08 #4

P: 49
If you like, how about sending me the Database as an E-Mail Attachment, and I'll look at it as soon as possible, If this is agreeable to you, please let me know and I'll send my E-Mail address to you as a Private Message.
I would actually woudnt mind, but the university i work for, would not allow this. would you have an idea about the other issue that i currently have the populate listbox?

Cheers mate
Jan 26 '08 #5

ADezii
Expert 5K+
P: 8,679
I would actually woudnt mind, but the university i work for, would not allow this. would you have an idea about the other issue that i currently have the populate listbox?

Cheers mate
I'll look at it as soon as I get a chance.
Jan 26 '08 #6

P: 49
I'll look at it as soon as I get a chance.
Would you have any other ideas to solve this issue?
Jan 27 '08 #7

ADezii
Expert 5K+
P: 8,679
Name of product table = tblproduct
Order table = tblorder
total quantity field = Quantity
Quantity field in order table = well i have the current stock which represents the total within the product table, which is called stock1, and then quantity1 which is the amount which they order and then i added a newquantity within the order table which represents the stock - quanity and the newquantity should be updated within the product table.
frmorderform is where the info is being entered
in the order form i have a field called txtstock1, which is the record from the product table, then cboquantity1, this is where u select the quantity which is requried.
You never answered Question #5.
Jan 28 '08 #8

Post your reply

Sign in to post your reply or Sign up for a free account.