If I define a valuelist to use database values through a relationship, I am missing values in the list. If I load the records into a form through the same relationship, the expected number of records appear in the foundset. My relationship uses a global on the left that gets an initial value that corresponds to a value in the related table. For example, a global named ‘gconstant_yes’ gets an initial value of ‘Yes’, and in the ‘users’ table, a column named ‘is_active’ gets a value of either ‘Yes’ or ‘No’. Here is a weird thing I found while troubleshooting. In one case, if I put two copies of the same field with the same valuelist attached to the fields, one field shows all but one of the related values. The other is missing 20 values. I have tried different relationships and the problems seems consistant. In all cases, I have checked to be sure that both fields in the relationship are defined alike (both integers, both text, etc.). I tested my solution in RC5 and the value list appears correctly. Once I upgrade Servoy to 2.2 RC6 or higher, the valuelist is missing values.
Thank you,
Steve in LA