473,503 Members | 1,678 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

I want to update a field of a table from other table on Run_time.

5 New Member
Hello to everybody!

I want that during inserting values in the master/detail form whenever I select a Company ID and enter BILL Amount against that company and SAVE that record then It should SAVE that entered values of that BILL_AMOUNT in COMPANY table field Total_Amount_Purchased/Total _Amount_Reapair.

Actually TOTAL_AMOUNT_PURCHASED/TOTAL _AMOUNT_REAPAIR are the fields that hold the amount of business that each company will make in each BILL.

But it should be in view that COMPANIES are not involved in each BILL case but I want that whenever a COMPANY is involved in any BILL then its business record should be (in amount) saved automatically in COMPANY table’s Total_Amount_Purchased or Total _Amount_Reapair fields.
Thanks & Regard.

(All four tables were attached to the previous message).
Nov 23 '06 #1
1 1118
pragatiswain
96 Recognized Expert New Member
Hello to everybody!

I want that during inserting values in the master/detail form whenever I select a Company ID and enter BILL Amount against that company and SAVE that record then It should SAVE that entered values of that BILL_AMOUNT in COMPANY table field Total_Amount_Purchased/Total _Amount_Reapair.

Actually TOTAL_AMOUNT_PURCHASED/TOTAL _AMOUNT_REAPAIR are the fields that hold the amount of business that each company will make in each BILL.

But it should be in view that COMPANIES are not involved in each BILL case but I want that whenever a COMPANY is involved in any BILL then its business record should be (in amount) saved automatically in COMPANY table’s Total_Amount_Purchased or Total _Amount_Reapair fields.
Thanks & Regard.

(All four tables were attached to the previous message).
Pls. check the discussion thread http://www.thescripts.com/forum/thread567445.html
Nov 23 '06 #2

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

Similar topics

1
2512
by: Tony Johnson | last post by:
I want to update a particular field in a form for only a certain set of records. The certain set of records is named Financed. I need to update those Financed records with a financed number that...
22
18762
by: RayPower | last post by:
I'm having problem with using DAO recordset to append record into a table and subsequent code to update other tables in a transaction. The MDB is Access 2000 with the latest service pack of JET 4....
1
2363
by: Norma.Caskey | last post by:
I am trying to figure out how to update a field in a table ONLY if it matches a criteria. In this example, I have a sales opportunity (with a unique identifier). Each month we pull the sales...
4
1762
by: cacanene | last post by:
My question is what will be the fast algorithm to add records in a table based on the value of a field of other table. For example: TABLE2 contains two fields ID and DESCRIPTION TABLE1 contains...
4
1897
MitchR
by: MitchR | last post by:
Good Morning; I have an issue that I need to guidance to resolve. I have a table called return_tbl with about 25k records. I have 23 Fields in this table. I am looking to update 3 of these 23...
6
5837
by: KevinPreston | last post by:
Hello everyone, this is my first post so apologies if i dont get it right first time, i am a self taught Access user, i am stuck on something i am trying to do, briefly i have 2 tables, one for...
1
1757
by: hinze | last post by:
Hi, this is my first ever post, so go easy on me... I want to update some fields from table 'cases' to some fields in another table 'casesandcontrols'. For example I want to add the PSA data from...
2
1362
by: ujwala udgaonkar | last post by:
I created a table contains value1, value2 and average. I created a form to enter data and calculate average as value1+value2. In form, it shows actual result but data is not updated in table. Why?
2
3487
by: scoots987 | last post by:
Hi all, sorry if this is the wrong place to put this. I have two tables, both contain address info. I would like to update address1, address2, city, state, zipcode and country. May be a few...
7
3465
by: nhkam | last post by:
I am using MS Access 2007 I have a transaction table which holds all records with posting date on each of them. I used a make table query to find out the max date hold in the transaction table and...
0
7201
marktang
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,...
0
7083
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7328
jinu1996
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...
1
6988
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
4672
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...
0
3166
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
1510
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
734
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
379
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.