This example demonstrates how data sets can be linked together to allow picklists to fill in the data. Here, the 'Position' field is single-select, whereas 'Office' can have multiple values assigned. You can also configure the selection type to be a checkbox control, radio buttons or a select control (either single-select, or multi-select). This YouTube video demonstrates how to create a linked data set.
Below are the three data sets - the employee table, one for the offices and one for the positions. You'll notice that if you add or change a value to one of the link data sets, as discussed in the Live Data example, that change will be reflected immediately in the employee data set. This will also be the case for anyone else viewing the data set in your app.
We are working on building up more examples of CloudTables. Please stay tuned, they're on their way!