Sorry for that
Actullay i m developing a database for CONTINGENCY Bills relating to A/C.
my previous problem has been solved.
I want now that after a company has made business of some specific limit like Rs. 25,000, then there should be condition of TAX deduction on that particular amount with some specific rate like 6%.
Table structure is there is the previous thread.
I will be...
soahil
Last Activity: Dec 23 '06, 05:18 AM
Joined: Nov 22 '06
Location:
-
i want to calculate tax amount
Thanks to Pragatiswain
I have two table with follwing structure
table no:1 BILL_DETAIl
Name Null? Type
------------------------------- -------- ----
BILL_ID NOT NULL NUMBER(38)
S_HEAD_CODE NOT NULL VARCHAR2(12)
SR_NO NOT NULL NUMBER(38)
BILL_AMOUNT... -
I want to update a field of a table from other table on Run_time.
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_Pu rchased/Total _Amount_Reapair.
Actually TOTAL_AMOUNT_PU RCHASED/TOTAL _AMOUNT_REAPAIR are the fields that hold the amount of business that each company... -
I want to update a field of a table from other table on Run_time.
Hi and thanks to pragatiswain for reply.
i tell u about tables in the database.
TABLE NAMES are "SUB_HEAD","CAT EGORY","COMPANY ","BILL","BILL_ DETAIL.
I've a master detail relationship b/w BILL and BILL_DETAIL FORM.
Master table is "BILL" and Child table is "BILL_DETAI L".
and also CATEGORIES and COMANY tables values are dependent... -
want to update records of 2nd table when i insert values in 1st table
hello
I am facing a problem.
i have two tables named "BILL_DETAI L" and "COMPANY"
both structure is as follws:
---------------------
"BILL_DETAI L"
---------------------
BILL_ID NOT NULL NUMBER(38)
S_HEAD_CODE NOT NULL VARCHAR2(12)
SR_NO NOT NULL NUMBER(38)
BILL_AMOUNT ...
No activity results to display
Leave a comment: