query

[awake2424]

I have a tblCommets that has 2 columns in it. The first is an identifier (1,2,3) and the second column is a comment associated with that identifier. Is it possible to use a query to pull that comment based on a user selection? So, if the user selects 1 then the comment associated with 1 is pulled, but if the user selects 2 then that comment results. Thank you.

 =Select[tblComments].Column(2)

 

[Mr Smin]

Can you describe more about the situation in which the user makes the selection?

You might want to try using the ComboBox wizard on a form as this walks you though a user selecting one option among many and storing an identifier based on the selection.