Valuelist

Classic Servoy
1

I have this situation: one table with one id field; the tables linked to this id fields are two depending on another field of the same table. I need to do a form with a table view on this table and i have to display not the id fields but its “translation” taking it from the source table 1 or from table 2 depending on value of field type (value 1 or 2). Which is the correct way to manage this situation ?
Thanks

2

I think you need to create a calculation that, based on the type field, uses a different relation to show the related translation:

if (type == 1) {
	return table_to_table1.translation;
} else if (type == 2) {
	return table_to_table2.translation;
}
3

Thanks, at the moment it was the solution i have used…