[Solved] Suitable "Form navigator tree structure"?

[amzg]

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!

[MSPhobe]

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.

[amzg]

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

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
(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.