[Kexi] Form with more fields from several tables

[Jarosław Staniek]

Sergio Belkin said the following, On 2007-05-23 17:56:
> I was trying to use OpenOffice.org Base with his own embedded engine (hsql), 
> but since I've stuck with a lot of problems, I've decided to install and use 
> Kexi, even I knew, really I'found kinda developed.
> 
> Even, I've found easier and more usable than OOo Base. The way of creating 
> tables is easier and more complete, even it hasn't form wizard, way it has to 
> create is kinda easy. However, I have a little issue: I can't create a form 
> fields from several tables. Only I can create forms with fields from only and 
> only one table. Is that a feature or a bug?  :)
> 
> I am using koffice-kexi-1.6.2-2mdv2007.1 on Mandriva Spring x86_64. I am using 
> no dataserver.

Hello,
Thank you for your interest. You can create a query using joins 
(relationships) in the Query Designer and then use the query as data source 
for your form. The only (but annoying drawback) is that data coming from 
queries is currently read-only in Kexi.

If you're looking for subforms (another way of displaying relational data in 
forms), I'll tell you there are no subforms in Kexi yet.

-- 
regards / pozdrawiam, Jaroslaw Staniek
  Sponsored by OpenOffice Polska (http://www.openoffice.com.pl/en) to work on
  Kexi & KOffice: http://www.kexi.pl/en, http://www.koffice.org
  KDE3 & KDE4 Libraries for MS Windows: http://kdelibs.com, http://www.kde.org