It would be valuable to be able to use a union query to combine multiple queries into a single result. For example, suppose your database has two unrelated tables where one stores customer data and another stores data about suppliers – and both tables have a contact information field. You’d like to see the contact information from both tables in one view. We cannot do this today in Capsio like we can in SQL Server or even MS Access. To do this, we would need to create a view for each table to retrieve the contact information, and then combine those results by creating a union SQL query using the UNION syntax. Very useful for combining data. Others on the Capsio forum have expressed interest in having this feature as well.
Best practice is to store metadata with multiple values, in a separate linked table. This is a bit cumbersome in Caspio using child forms. So when the number of multiple values is limited to 2 or 3, one can opt to include these as different fields in the main table (for example 2 to 3 keywords for an object) . To do any reporting on these 2 to 3 keywords, one would need to union the values in the 2 or 3 fields.