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

[Solved] Suitable "Form navigator tree structure"?

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


Joined: 04 Jul 2009
Posts: 13

PostPosted: Fri Jul 17, 2009 10:30 am    Post subject: [Solved] Suitable "Form navigator tree structure"? Reply with quote

I have the following tables and would like a form with a Textbox showing the Flowername on top and then two listboxes respectively listing all relevant AxDescriptions for the flower.

What is a suitable "Form navigator tree structure" for this?


Table 1: FlowerTable
FID: integer, primary key
Name: text

Table 2: Attributes1Table
A1ID: integer, primary key
A1Description: text

Table 3: Attributes2Table
A2ID: integer, primary key
A2Description: text

Table 4: Linktable
ID: integer, primary key
FlowerID: integer <- this filled with integers from FlowersTable.FID
Attrib1ID: integer <- this filled with integers from Attributes1Table.A1ID
Attrib2ID: integer <- this filled with integers from Attributes2Table.A2ID



Thank you!


Last edited by amzg on Sat Jul 18, 2009 6:24 am; edited 1 time in total
Back to top
View user's profile Send private message
MSPhobe
Super User
Super User


Joined: 29 Sep 2005
Posts: 529
Location: England

PostPosted: Sat Jul 18, 2009 1:55 am    Post subject: Reply with quote

An "answer" to this is online at....

http://sheepdogguides.com/fdb/TwoAttrib.odb

... in the form of a database with the two subforms.

How it was done has been written up as...

http://sheepdogguides.com/fdb/fdb7twoattrib.htm

... and the following may be helpful....

http://sheepdogguides.com/fdb/fdb3cascselc2.htm

... may help.
Back to top
View user's profile Send private message
amzg
General User
General User


Joined: 04 Jul 2009
Posts: 13

PostPosted: Sat Jul 18, 2009 6:23 am    Post subject: Reply with quote

Ha ha! I followed your links and the sites made me go; "Wow, this really looks like spot on relevant information. What incredible luck that MSPhobe happened to know of a great website describing exactly my problem!"

...and after a few minutes I realized who the creator is Laughing

I will study what you've written meticulously.

As a gesture for my appreciation and sticking with the topic, here's a beautiful bouquet for you Idea
(as is obvious, it is still in its white paper wrapping).

Joking aside; This is SO kind of you! Thank you!!!!!


P.S 1: In your description, you quote my initial question, but the first sentence does not wrap so one has to scroll your page horizontally.

P.S 2: imagine using multiple subforms cannot be very uncommon. It would make sense that the wizard asked "Do you want to create yet anoter subform?" and simply repeat those wizard steps.
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