Chat GPT has been sending me on a goosechase, and I haven’t found what I need in the manual, using Kexi 3.2 (Linux) and the built in (SQLite?) database:
-
Is it possible to create a form with multiple table as datasources? I can create a query joining two tables on pk/fk then use the query as a data source for a form but I cannot enter data via query.
-
Is it possible to display all the matching ‘many’ side of such a query? Think a form based on business and a subform or table/grid of various addresses for that business (main, billing, PO Box etc). I do not see any widgets to do this, nor anything in the current discuss forum (archived forum is difficult to search so it’s possible I missed something. AI says I should create another form and insert it into the main form via a “frame” but I see no way to do that either. Basically the ideal widget would be a table with selected fields filtered for the main form current record (similar to Table Control in Libre Office base)
-
Is there a working IRC chat server? Matrix server is not allowing registrations.