So I have 2 tables. One for general information, the other is to enabled a drop down box in the form. I can’t select different tables. I will select one table for data entry, but when I try to configure the second table for the drop down box, it switches every table in the form to that table. I hope the gif helps clarify.
18 views over 2 years and no answer. I’ve only used Kexi for about a day, but I believe I read somewhere you can’t have multiple table/query datasources on same page and my Kexi 3.2 (Linux) version seems to confirm that. I read but have not yet tested, that the workaround is to create a query that includes everything you want to display, and use that query as your data source.
I just tested the query as datasource method of providing multiple tables to a form. Two caveats appeared quickly:
- Form fields are read only (greyed out text fields)
- There does not appear to be a way to show the ‘many’ side of a 1:M relationship without duplicated “1” entries. In other words, a book Table and an Author table with an author who has written multiple books, when tables are joined in a query will create a separate record for every book & author combination (no ‘Table control’) to display the multiple books. If I am wrong, please correct me because I really would like to have that ability (multiple phone numbers for each business displayed on a single form etc).