list

[cuadromoreno]

Cant find any comments on "LIST([THIS ROW])". Don't know if it does what I want. I need to show an Enumlist as a list in a column of other table.

Thanks

[graham_howe · Accepted solution]

When you're accessing another table you are accessing the data recorded in that table. This is not the same as accessing the options which could have been entered into the table. Here is an example:

1. assume I have a table rainbow with an EnumList for column [colours]

2. Assume [colours] has hard coded options of "red", "orange", "yellow", "green", "blue", "indigo", "violet".

3. Let's add some rows to this table

ID	colours
1	red , green , blue
2	blue , violet
3	yellow
4	red , yellow

 I can certainly write an expression like this:

rainbow([colours])

 But that would return all values from the column: 

red , green , blue , blue , violet , yellow , red , yellow

I could easily filter out the duplicates by wrapping that expression in UNIQUE(), but I would still be missing "orange" and "indigo" because they are not populated anywhere in the table.

So, if you actually want to be able to reference the entire list of [colours] which are available, regardless of whether they have ever been selected, then you should actually populate the EnumList from another table, as a reference.

Take a look at the following article in the help documentation.

	References Between Tables
	Learn about references, when to create them, and how to use them so your data makes sense.

[cuadromoreno · Accepted solution]

Excellent !!! Thanks so much

Luis Cuadro Moreno

[WillowMobileSys]

An EnumList is already a List.  

It's not clear what you are trying to do.  When you say, "show an EnumList as a List in a column of other table", this can refer to several things.  Do you mean as a list of dropdown options to choose from for your column?   Do you mean to simply show a comma separated list of items?  Something else?

[graham_howe · Accepted solution]

When you're accessing another table you are accessing the data recorded in that table. This is not the same as accessing the options which could have been entered into the table. Here is an example:

1. assume I have a table rainbow with an EnumList for column [colours]

2. Assume [colours] has hard coded options of "red", "orange", "yellow", "green", "blue", "indigo", "violet".

3. Let's add some rows to this table

ID	colours
1	red , green , blue
2	blue , violet
3	yellow
4	red , yellow

 I can certainly write an expression like this:

rainbow([colours])

 But that would return all values from the column: 

red , green , blue , blue , violet , yellow , red , yellow

I could easily filter out the duplicates by wrapping that expression in UNIQUE(), but I would still be missing "orange" and "indigo" because they are not populated anywhere in the table.

So, if you actually want to be able to reference the entire list of [colours] which are available, regardless of whether they have ever been selected, then you should actually populate the EnumList from another table, as a reference.

Take a look at the following article in the help documentation.

	References Between Tables
	Learn about references, when to create them, and how to use them so your data makes sense.

[cuadromoreno · Accepted solution]

Excellent !!! Thanks so much

Luis Cuadro Moreno

[cuadromoreno · Accepted solution]

Thanks so much!!