Column with a dropdown list

[#1]

I have 2 tables, Table 1 is a summary of the parameters obtained from a set of curves; Table 2 is the x and y column of  the curve itself. Both are virtually joined using a "primary/Reference key")

I am classifying the curves in table 2 based on its shape and the associated defects.

I want to create a column in summary table-Table 1 which has a drop down list of certain defects.which repeats ( eg: Low F; Low I, Low V etc). So that I can pick and choose the appropriate one instead of typing it( to avoid mistakes- The examples shown here are simple, but I have lengthier descriptions/combinations of some of the above). I also need an option to modify the drop down list box- where I can add new defects like "One Step" or "kink" etc.

How can I accomplish this?

[#2 · Accepted solution]

The List Check property is what you're looking for.

 

 

[#3]

Thank you. I came across "list check" before, but missed the "add a value" txt box beneath the box where it aggregates all the values. Since I was not able to enter the values there, I was not sure, Thanks for your clarification

[#4 · Accepted solution]

If you set the "List Check" column property for the columns in question, you can right click on a given cell and see the Approved values and select the value one wants.

[#5]

Thanks.