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?
7  1943 
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?
- What is the name of the Product Table?
- What is the name of the Order Table?
- Is there a Total Quantity Field for each Product? If so what is its name?
- What is the name of the Quantity Field in the Order Table?
- 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).
- What is the name of your Form where the Order info is being entered? Is it a Sub-Form?
- What is the name of the Quantity Field on the Order Form/Sub-Form?
- I think you get the idea by now...
- What is the name of the Product Table?
- What is the name of the Order Table?
- Is there a Total Quantity Field for each Product? If so what is its name?
- What is the name of the Quantity Field in the Order Table?
- 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).
- What is the name of your Form where the Order info is being entered? Is it a Sub-Form?
- What is the name of the Quantity Field on the Order Form/Sub-Form?
- 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.
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.
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
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.
I'll look at it as soon as I get a chance.
Would you have any other ideas to solve this issue?
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.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: chriskoch |
last post by:
I am running a DTS Package.
I have a temp table with 1494 records. I am inserting a 'Y' or
'N'into a temp table #HasClaims.
The TempTable name with the Provider Id's(PRPR_ID) is...
|
by: tom |
last post by:
I am new to SQL administration.
>From a list of IDs that are the primary key in one table (i.e. Customer
Table), I want to make changes in tables that use those IDs as a
foreign key.
...
|
by: Foxster |
last post by:
in access i have two tables (tblplayer, tblpoints)
in tblplayer i have field totalpoint (number)
in tlbpoints i have field pointgame (number)
the two files are related via idplayer
now i made a...
|
by: Chris Jackson |
last post by:
I'm a novice Access user and am not sure how to solve the following problem.
Any help with the following would be greatly appreciated!
I have two tables with identical structures, the first holds...
|
by: |
last post by:
I am updating MS access tables with data in an xml
document. I create two dataset, one for existing data and
one for new data. I fill the first dataset with the
records from MS Access, the second...
|
by: Mr Newbie |
last post by:
HI People,
Thanks to all who helped me earlier on the subject of @@IDentity. However, I
seem to have hit another snagette!
My DataSet contains two tables from the SQL Server. lets say Master...
|
by: davidgordon |
last post by:
Hi,
If I am updating a list of records for a user on an asp page, is there
a way to hold the page updating, even if they refresh the page, until I
have updated all the records.
i.e. rather...
|
by: Jeff |
last post by:
For years I have been using VBA extensively for updating data to tables
after processing. By this I mean if I had to do some intensive processing
that resulted in data in temp tables, I would have...
|
by: Alexey.Murin |
last post by:
The application we are developing uses MS Access 2003 database (with
help of ADO).
We have noticed that during massive records updating the size of the
mdb file increases dramatically (from 3-4 to...
|
by: ebs57 |
last post by:
I am looking for some basic help in understanding and setting up table relationships in Access.
I've created one table called PROJECTS and it has the field JobNo which I've declared as the key...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
| |
