OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Beginner: List Box question

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
Billaboard
General User
General User


Joined: 12 Feb 2012
Posts: 6

PostPosted: Fri Feb 17, 2012 8:18 am    Post subject: Beginner: List Box question Reply with quote

I have a form with 3 fields, Location (Primary Key), Title, Format in a table called LocationTable.
I have a subform containing the main data in a bunch of fields including Index (Primary Key) and Location, Location is related to Location in the other table.

The form and subform list the contents of the two tables and, if I select any location in the main form, the contents of that location are displayed in the subform.

If I now create a listbox based on my LocationTable and displaying the Location, I get no option to pull down any list - it just follows what is selected in the main form.
The database is called Music and the Control area of the listbox contains the following SQL.

SELECT `Location`, `Location` FROM `Music`.`locationtable`

I'm using MySQL for the database, but it seems to be the same using Base with its own database.

I'm obviously not understanding something basic here. Any help?
Back to top
View user's profile Send private message
RPG
Super User
Super User


Joined: 24 Apr 2008
Posts: 2697
Location: Apeldoorn, Netherland

PostPosted: Fri Feb 17, 2012 8:46 am    Post subject: Reply with quote

Hello

I think start here reading
http://user.services.openoffice.org/en/forum/viewtopic.php?f=83&t=28235

Romke
Back to top
View user's profile Send private message
Billaboard
General User
General User


Joined: 12 Feb 2012
Posts: 6

PostPosted: Fri Feb 17, 2012 1:14 pm    Post subject: Reply with quote

Hello Romke, I have read through that guide and understood most of it, but I am afraid that I feel even more stupid.

The basic problem remains that I can use the form wizard to create a grid display of the main form and subform, and they link together fine.

I then use the ListBox wizard to create a Listbox, but the ListBox pull down does nothing and the data shown in the ListBox follows the selection in the main form rather than leading it.

I have followed pictorial and video tutorials about this and then tried to follow parallel procedures, but cannot get the ListBox to work the way I expect.

As is obvious, I am really at a very early learning stage with this and I do appreciate the help/

Bill
Back to top
View user's profile Send private message
RPG
Super User
Super User


Joined: 24 Apr 2008
Posts: 2697
Location: Apeldoorn, Netherland

PostPosted: Fri Feb 17, 2012 1:32 pm    Post subject: Reply with quote

Hello

Quote:
but cannot get the ListBox to work the way I expect
Then change those thing you expect that is much more easy then changing OOo. In other you do not understand how OOo is working

Study the tutorials where I did point to in the link.

The purpose of a listbox is:
a) Show a value from an other table.
b) Changing the table while you select a value from an other table.
Quote:
I then use the ListBox wizard to create a Listbox, but the ListBox pull down does nothing and the data shown in the ListBox follows the selection in the main form
So it works

Quote:
rather than leading it
This is a wrong expectation.

I have no idea how to get what you want.

Romke
Back to top
View user's profile Send private message
RPG
Super User
Super User


Joined: 24 Apr 2008
Posts: 2697
Location: Apeldoorn, Netherland

PostPosted: Fri Feb 17, 2012 1:57 pm    Post subject: Reply with quote

Hello

Learn searching on the forums.

Search on the author DACM
and then for listbox

I think search on the new forum and not his forum

http://user.services.openoffice.org/en/forum/viewtopic.php?p=164740#p164740

Romke
Back to top
View user's profile Send private message
Arineckaig
OOo Advocate
OOo Advocate


Joined: 01 Mar 2004
Posts: 358

PostPosted: Sat Feb 18, 2012 2:40 am    Post subject: Reply with quote

Billaboard
Quote:
the data shown in the ListBox follows the selection in the main form rather than leading it.

Please forgive me if I do not fully appreciate what it is that you want the listbox to do. From the quote above it would appear that you wish the content of your MAIN form to be selected/filtered by a selection made from a drop-down listbox. If that is so, I would suggest that in Base a listbox is not well suited to that purpose unless resort is made to macro programming. In Base a listbox is essentially a form control suitable for displaying, adding or changing data in a field of the database - of itself it cannot filter the recordset displayed by the form in which the listbox is located (contained).

On the other hand you will already have seen that any change of the record selected in your MAIN form automatically selects and filters the record(s) displayed in the SUBFORM. Thus, the main form is performing on the sub-form the task that I suspect you may be asking of the listbox to do on the main form. The solution is to insert a further main form above what you have at present so the previous main form becomes its sub-form and the previous sub-form a sub-sub-form. The Base wizards are too limited to do this, but it can be done by opening the form document in edit mode. The links that RPG gave you indicate how to modify a form document in edit mode. Please come back if you wish further guidance.

If all goes well, the newly created main form should be based on the same data source as its sub-form (previously the main form) and again comprises a grid/table but it only needs to contain a single text box "Location" column. Selection of any item from this column will automatically filter and update the recordset(s) displayed in any subform provide the subform is suitably linked. Selection from the Locations column in the main form is simplified if the 'Sort' property under the 'Data' tab of the form's 'Form properties' dialog is set to the "Location" field to be sorted alphabetically.

The operation is more complicated to explain than to do, but without making use of a form document's 'edit mode' only the simplest of forms and form documents are available in Base.
_________________
When this issue has been resolved, it helps other users of the forum if you add the word [Solved] to the Subject line of your 1st post (edit button top right).
OOo 3.4.1 and MySQL on MS Windows XP and Ubuntu
Back to top
View user's profile Send private message
Billaboard
General User
General User


Joined: 12 Feb 2012
Posts: 6

PostPosted: Sat Feb 18, 2012 11:52 am    Post subject: Reply with quote

Many thanks for these replies. I will settle down to read through all the references again.

I will have to get this, or some other interface to work graphically, but the data will have to be entered as it becomes available, which will take me away from this, or at least slow me down.

I am not having much luck with any of this. For example I tried to follow the instructions for adding an additional mainform, but right clicking on the Forms screen brings up no 'new' option as described in RPG's document.

I think the ListBox problems I'm having are because I was used to programming in Borland C++ some years ago, and expected ListBoxes to work similarly to that.

Thanks again.
Back to top
View user's profile Send private message
RPG
Super User
Super User


Joined: 24 Apr 2008
Posts: 2697
Location: Apeldoorn, Netherland

PostPosted: Sat Feb 18, 2012 1:25 pm    Post subject: Reply with quote

Hello

If you have experience with programming then it can help you, to see the forms as a programming tool. You are programming with SQL and not with C++.

Romke
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group