excuse me for my bad english...
I'm working around a database with kexi.
it is for a school and so I have 2 tables: - class and -students
I've builded a query and now I want to see in a form the class
and in a "subform" all the students in a table.
is it possible?

thank you!

Dino

Subforms are not supported in Kexi 2.4 and earlier. The only way for working with relationships is at the moment via combo boxes (within forms or tables).

We know how much expected is this feature, so it's on our priority list.

Are subforms supported in 2.7 and if not can anyone suggest a work around?

gregfordyce wrote:Are subforms supported in 2.7 and if not can anyone suggest a work around?

They are not supported in 2.7. Possible imperfect workaround would be to design a parametrized query that takes search criteria.

Unfortunately:
- The result of the query will be non-editable
- You have to enter the exact full parameter. However if you're a little bit more advanced user and go to the SQL view and replace 'column = [Enter value]' condition in a query like:

Code: Select all

SELECT * FROM mytable WHERE column = [Enter value]

with 'LIKE [Enter value]' condition:

Code: Select all

SELECT * FROM mytable WHERE column LIKE [Enter value]

then user might be able to search substrings. To do so he should start and finish the substring with % character, eg. this will return any records containing 'jack' substring in given column:



The search is case-sensitive.

Hope this hint full of workarounds somehow helps you.