Re: Question

Hi Cory,
You want to use the validate feature to pick from the 'Select' column in your table. Put the cursor in the 'key' cell (I'll use A2), then select 'data / validity'. On the 'criteria' tab allow 'Cell Range', then enter the address of the 'Select' data in the 'Source' box in the form A3:A99, assuming that the data is in column A from row 3 to row 99. An arrow should appear next to A2 when that cell is selected. Clicking the arrow should pop up a list with the data in column A. In each of the three cells beside the key cell enter the following formulae:
In B2:

=IF(A2<>"";VLOOKUP(A2;$A$3:$D$99;2;0);"")
In C2:

=IF(A2<>"";VLOOKUP(A2;$A$3:$D$99;3;0);"")
In D2:

=IF(A2<>"";VLOOKUP(A2;$A$3:$D$99;4;0);"")

When you select an item from the list, the data from that item's row in your table should appear in the three cells next to it. I've attached a sample file. I'm not sure if it will make it to the list.

tc



>________________________________
>From: Cory Heskamp <[email protected]>
>To: [email protected]
>Sent: Thursday, September 29, 2011 7:21:00 PM
>Subject: [users] Question
>
>
>I am sure this is a stupid question but I can not seem to find the answer. I want to be able to set it up that in Calc I select one entry (Primary Key) from a database from a combo box but that it will update the rest of the entries in that field in other areas. Not sure if I am explaining this right. I have a database with the following table called payroll. Inside the table there is 4 items in each entry. Select, Type Description, and Code. What I want is that in Calc I have a cell that is setup as a combo box linked to the Select field of the table, but I want it that when I select that item it will take the information in the rest of the item (Type, Description, and Code) and put that stuff in other individual cells. Basically I select the entry I want from the combo box and it fill out the corresponding information into a cell for Type, a cell for Description, and a cell for Code. That way all I have to do is edit the database and then in the Calc
 select the item and it will fill in all the cells. Does this make sense? Can someone help me?
> 
>Thanks in advance
> 
>Cory
>
>