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 > >
PickDataExample.ods
Description: Binary data
