Documentation for Combo boxes and the like

[Manfred Jung]

Hi all

Kexi might be my answer to getting rid of a certain micro$oft program.
but im new to Kexi and have to unleran some of the old habits. i suppose.

I tried fiddling around with combo boxes looked at the documentation
(hanbook), found nothing (I might be looking in the wrong places). I
also searched the mailing-list. I looked a the Sample database and there
is a combo box working. But i could not find where the como-box gets
told where to fetch the data to display in the drop down section.
Further I don't see where the combo-box is told which is the bound
column. etc.

Is there some documentation on the various controls Kexi uses?

One more thing. Does Kexi have something that M$ Access calls a subform?

Any help or pointer to the right documentation is most appreciated.

manfred


_______________________________________________
Kexi mailing list
Kexi@...
https://mail.kde.org/mailman/listinfo/kexi

[Jaroslaw Staniek-2]

2009/2/5 Manfred Jung <mjung@...>:

> Hi all
>
> Kexi might be my answer to getting rid of a certain micro$oft program.
> but im new to Kexi and have to unleran some of the old habits. i suppose.
>
> I tried fiddling around with combo boxes looked at the documentation
> (hanbook), found nothing (I might be looking in the wrong places). I
> also searched the mailing-list. I looked a the Sample database and there
> is a combo box working. But i could not find where the como-box gets
> told where to fetch the data to display in the drop down section.

Hi,
- in the table designer, lookup column tab on the right hand; in the table
data mode you'll see comboboxes

So in the table designer, just select table in the lookup column tab
on the right hand and a bound column within this table (the same
pane). In the example database, click on the 2nd tab to see how this
has been set up.

- in the form designer - once you have lookup columns in your table's
project, you can
put combo boxes onto your form (use similar lookup field tab)

see the 2nd tab here
http://www.kexi-project.org/pics/1.1.1/lookup_column_design.png

> Further I don't see where the combo-box is told which is the bound
> column. etc.
>
> Is there some documentation on the various controls Kexi uses?
>
> One more thing. Does Kexi have something that M$ Access calls a subform?

it's not available yet

> Any help or pointer to the right documentation is most appreciated.

It's here: http://docs.kde.org/kde3/en/koffice/kexi/index.html
In particular 'http://docs.kde.org/kde3/en/koffice/kexi/designing-forms.html'
(Most important terms) is, well... important.


--
regards / pozdrawiam, Jaroslaw Staniek
_______________________________________________
Kexi mailing list
Kexi@...
https://mail.kde.org/mailman/listinfo/kexi

[Manfred Jung]

Thanks so much

I see the concept here is quite different but also logical. In access you define such relationship for the combo box itself regardless of the tables and their relationships. Thanks this helped a lot.

The combo-box displays in the drop down contents of the underlying table. Is there a way to say which fields should be displayed?

But Thanks so much for getting me going.
MJ

Jaroslaw Staniek wrote:

2009/2/5 Manfred Jung mjung@...:
  

Hi all

Kexi might be my answer to getting rid of a certain micro$oft program.
but im new to Kexi and have to unleran some of the old habits. i suppose.

I tried fiddling around with combo boxes looked at the documentation
(hanbook), found nothing (I might be looking in the wrong places). I
also searched the mailing-list. I looked a the Sample database and there
is a combo box working. But i could not find where the como-box gets
told where to fetch the data to display in the drop down section.
    

Hi,
- in the table designer, lookup column tab on the right hand; in the table
data mode you'll see comboboxes

So in the table designer, just select table in the lookup column tab
on the right hand and a bound column within this table (the same
pane). In the example database, click on the 2nd tab to see how this
has been set up.

- in the form designer - once you have lookup columns in your table's
project, you can
put combo boxes onto your form (use similar lookup field tab)

see the 2nd tab here
http://www.kexi-project.org/pics/1.1.1/lookup_column_design.png

  

Further I don't see where the combo-box is told which is the bound
column. etc.

Is there some documentation on the various controls Kexi uses?

One more thing. Does Kexi have something that M$ Access calls a subform?
    

it's not available yet

  

Any help or pointer to the right documentation is most appreciated.
    

It's here: http://docs.kde.org/kde3/en/koffice/kexi/index.html
In particular 'http://docs.kde.org/kde3/en/koffice/kexi/designing-forms.html'
(Most important terms) is, well... important.


  

_______________________________________________
Kexi mailing list
Kexi@...
https://mail.kde.org/mailman/listinfo/kexi

2009/2/5 Manfred Jung <mjung@...>:
> Thanks so much
>
> I see the concept here is quite different but also logical. In access you
> define such relationship for the combo box itself regardless of the tables
> and their relationships. Thanks this helped a lot.
>
> The combo-box displays in the drop down contents of the underlying table. Is
> there a way to say which fields should be displayed?

Yes there is -- see the "visible column" field on
http://www.kexi-project.org/pics/1.1.1/lookup_column_design.png

BTW, with 1) additional wizard for the feature and 2) MSAccess-like
possibility of designing the binding for combobox widget itself, I
hope one day more use cases will be covered.

--
regards / pozdrawiam, Jaroslaw Staniek
_______________________________________________
Kexi mailing list
Kexi@...
https://mail.kde.org/mailman/listinfo/kexi

By the way, corrently only one column can be declared as visible in
the "lookup column" pane.

--
regards / pozdrawiam, Jaroslaw Staniek
_______________________________________________
Kexi mailing list
Kexi@...
https://mail.kde.org/mailman/listinfo/kexi

[Manfred Jung]

Indeed You are right with thevisible column. this seems to be the collum
that gets displayed when a selection has been made and the drop down
combo box is closed. Nevertheless kexi displays mor than one column in
the drop down part of the combo box if the underlying table has more
than one column. This is nice but it would be better to find a way to
decide which columns gets displayed and in which order. But I understand
kexi is a project in progress. and so far I like what I see.

One more question if I may. There seems to be no wiggit  to display a
table in a form. (ie more than one  record in a list). I would need this
in a form to display all phone numbers of a particular contact. The
phone numbers are saved in a seperate table since on person can have
many phone numbers. Or is there a better/different way of doing this in
kexi?

Thanks for all the help.

BTW apart from the handbook ther is no other help (baring the mailinglist)?

manfred

Jaroslaw Staniek wrote:
> By the way, corrently only one column can be declared as visible in
> the "lookup column" pane.
>
>  

--
Manfred Jung
CCM-Services
Tel     [phone]
Fax     [phone]
email   mjung@...

_______________________________________________
Kexi mailing list
Kexi@...
https://mail.kde.org/mailman/listinfo/kexi

2009/2/6 Manfred Jung <mjung@...>:
> Indeed You are right with thevisible column. this seems to be the collum
> that gets displayed when a selection has been made and the drop down combo
> box is closed. Nevertheless kexi displays mor than one column in the drop
> down part of the combo box if the underlying table has more than one column.
> This is nice but it would be better to find a way to decide which columns
> gets displayed and in which order. But I understand kexi is a project in
> progress.

You have no gui for setting up this yet even while the file format
allows for such definitions.
>
> One more question if I may. There seems to be no wiggit  to display a table
> in a form. (ie more than one  record in a list). I would need this in a form
> to display all phone numbers of a particular contact. The phone numbers are
> saved in a seperate table since on person can have many phone numbers. Or is
> there a better/different way of doing this in kexi?

Your use case is important, and by the way, it is similar to subforms
-- if we look at the way of interaction of the table view with the
parent form, it's similar to how subform interacts with the parent
form. Both things are on the TODO list, subforms first, then
sub-table-views.

--
regards / pozdrawiam, Jaroslaw Staniek
_______________________________________________
Kexi mailing list
Kexi@...
https://mail.kde.org/mailman/listinfo/kexi