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 -- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help
