Reply to topic

Form data source query

rockgibbon
Registered Member
Posts
3
Karma
0

Form data source query

Thu Aug 20, 2015 8:13 am
Hello. I'm new to using Kexi and am currently finding my way round the software (v2.9.6) while building a database. I'm really enjoying using it so far but have stumbled across an issue I can't solve and wondered if any one can offer a pointer?

My database has multiple tables and four forms. On one of the forms I would like to display data from at least three of the tables I have created so multiple widgets have fields from different data sources, unfortunately I can only seem to select one data source per form. I've looked in the manual and run a few Internet searches but cannot find a solution. Is there a way to do this in Kexi?

Thanks for any help any one can provide.

Best wishes,
Gareth.
User avatar jstaniek
Moderator
Posts
939
Karma
2
OS

Re: Form data source query  Topic is solved

Wed Aug 26, 2015 11:00 am
Hi Gareth
Thanks for using Kexi.
Subforms or split forms or would fit well, unfortunately they are not available.

https://bugs.kde.org/show_bug.cgi?id=330220
https://bugs.kde.org/show_bug.cgi?id=337440

If you join tables using query, all fields can be displayed. But on the other hand, the form's data becomes non-editable.

There's no usable solution for now except a frustrating one: copy/remember an an ID of a record you want to edit in given table, got to the table or its form (data view), search for the ID and edit the record. (Note that other views based on the table should be reloaded, what actually can be performed by closing and opening the view again).


Best regards,
Jarosław Staniek
Image

KEXI - Open Source Visual DB Apps Builder
• Request feature or fix for KEXI here
May I help you? Please mention your app's version and OS when asking for help
rockgibbon
Registered Member
Posts
3
Karma
0

Re: Form data source query

Fri Aug 28, 2015 10:11 am
Thanks very much for your reply.

That's a shame. I'll use your workaround for the time being, that should solve my problem.

Out of interest is such a feature planned for a future edition of Kexi?

Best wishes,
Gareth.
User avatar jstaniek
Moderator
Posts
939
Karma
2
OS

Re: Form data source query

Fri Aug 28, 2015 10:53 am
Thanks for understanding.

Yes, it's planned as a must-have feature, no milestone is set though.

Requesting features important for users: https://community.kde.org/Kexi/Contact# ... t_or_a_fix


Best regards,
Jarosław Staniek
Image

KEXI - Open Source Visual DB Apps Builder
• Request feature or fix for KEXI here
May I help you? Please mention your app's version and OS when asking for help
rockgibbon
Registered Member
Posts
3
Karma
0

Re: Form data source query

Fri Aug 28, 2015 11:28 am
Thanks Jarosław!

 
Reply to topic

Bookmarks



Who is online

Registered users: Baidu [Spider], Bing [Bot], Google [Bot], Invictus