View Full Version : cell1+cell2=cell3


sougatau
06-20-2006, 09:20 AM
Hi,
I am a newbe

I want to create a table

with 4 fields
1.name(pkey)
2. basic
3.da
4 salary (basic+da)

I want that when I put basic and da the 4th cell will automatically take the value. I don't want to use any form, just want to open a table and insert the values in 1st 3 feilds only , and then the value in 4th field wll automatically come.

Plz help me?

Sougata

KenHigg
06-20-2006, 09:24 AM
Under normal conditions you would never do as you've described. If you need the two fields combined for display, printing or export, you do it on the fly as you need it.

Pat Hartman
06-20-2006, 08:34 PM
Try not to think of table fields as cells. The two have little in common. When working with a relational database, you will have an easier time if you can completely remove your spreadsheet hat and put on your RDBMS hat. Do some reading on database design and normalization.