Populating a dropdown from a collection

[richard28494]

@code-queen Actually, I have now done this without code. I used a table rather than a dropdown list, but I suspect that if I went back and tried a dropdown list again, it would probably work. Deep down there are issues of validation not mentioned in the {not very good} documentation, and the lack of any error reporting that I have found, which means you have to try trial and error. The reason the original did not work seems to be as simple as things like insisting that the names of the fields in both tables are the same. This is a restriction that I cannot see a good reason for. If you state that Field X is a reference field to table Y, then by definition, it must be to the key of table Y, and the Wix programmers could simply look up the name of that. But, no, they seem to insist that the fields in both tables have the same names. Once I worked that one out (essentially by setting up two otherwise identical instances of the approach (one working and the other not working), and then looking to see if I could spot what was different about them), then it just worked.