Home > IT Answers > Development > Getting value of 3rd col when we enter first two col values
Swapnilsurve
15 pts.
 Getting value of 3rd col when we enter first two col values
Database programming
I hv data base with 3 cols. i want to wrte a formulae like when ever i giv two values the third value should automatically come

Software/Hardware used:
ASKED: June 15, 2009  11:12 AM
UPDATED: June 17, 2009  3:48 AM
RELATED QUESTIONS
Answer Wiki:
Could you be more specific? What program, language, etc.? -Schmidtw
Last Wiki Answer Submitted:  June 15, 2009  6:13 pm  by  Schmidtw   11,205 pts.
All Answer Wiki Contributors:  Schmidtw   11,205 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Please provide more details about the specific database and version. Different applications perform calculations in a different manner.

Troy Tate
 0 pts.
 

The data base is as folllows

A B C
Branch Dept Code
Mum it 141
Mum acc 142
Mum cdg 143
Del it 144
Del acc 145
Del cdg 146……

Like this the master data base contains this details

In a new sheet I want a formula that will automatically give me Code when i put Branch & Dept.

Swapnilsurve
 15 pts.
 

This is not really a database – rather a listing of items. How do you ensure that for same Dept and Branch there is not more than one Code? Need to define tables and their relationship.

If it is just plain data then you may be better off to use Excel.

Just an observation – may be I missd your point.

SbElectric
 2,510 pts.