Parent/Child Relationship through Listview


Author
Message
Philipp Guntermann
Philipp Guntermann
StrataFrame User (231 reputation)StrataFrame User (231 reputation)StrataFrame User (231 reputation)StrataFrame User (231 reputation)StrataFrame User (231 reputation)StrataFrame User (231 reputation)StrataFrame User (231 reputation)StrataFrame User (231 reputation)StrataFrame User (231 reputation)
Group: Forum Members
Posts: 141, Visits: 263
Hi,

scenario:

  • Table PropertyGroups:
    • ID
    • Name
    • Comment
  • Table Properties
    • ID
    • Name
    • PropertyGroups_ID
    • Comment

I have Maintanance form to add and modify the propertygroups allready.

Now on the Maintance form for the Properties, i'd have:

  • Textfield: Name
  • Combobox: PropertyGroup
  • Textfield: Comment

What i need is for the Combobox to allow selection of anyone of the Property-Groups from the PropertyGroups Table/BO, and saving the selected PK/ID from that Property Group into to Propertie-Table/BO PropertyGroups_ID column.

what is the proposed way to achieve that ?

thanks.

Trent Taylor
Trent Taylor
StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
I guess I am a bit confused.  From what I understand, it would just be a matter of populating a combo with the PropertyGroups and the binding to the PropertyGroups_Id on the child table....please let me know what piece I am missing or if this is what you were looking for.
Philipp Guntermann
Philipp Guntermann
StrataFrame User (231 reputation)StrataFrame User (231 reputation)StrataFrame User (231 reputation)StrataFrame User (231 reputation)StrataFrame User (231 reputation)StrataFrame User (231 reputation)StrataFrame User (231 reputation)StrataFrame User (231 reputation)StrataFrame User (231 reputation)
Group: Forum Members
Posts: 141, Visits: 263
hi,

yes this is what i am looking for.

i have a PropertyGroupsBO and a PropertiesBO. each one has a fill method.

They user shoud select a property group from the combobox (the propertygroup's name),
and then it should save that to the PropertiesBO.PropertyGroups_ID field. (the pk_id of the selected property group).

Edhy Rijo
E
StrataFrame VIP (4.7K reputation)StrataFrame VIP (4.7K reputation)StrataFrame VIP (4.7K reputation)StrataFrame VIP (4.7K reputation)StrataFrame VIP (4.7K reputation)StrataFrame VIP (4.7K reputation)StrataFrame VIP (4.7K reputation)StrataFrame VIP (4.7K reputation)StrataFrame VIP (4.7K reputation)
Group: StrataFrame Users
Posts: 2.4K, Visits: 23K
Hi Philipp,

See the picture attached that will give you a clear idea of how to setup your combobox.  In this case I have a method called FillAllRecords() in my BO base class and since I want to show all records in the combo, I chose that method then, set the lookup bo PK field in the Value Member to be updated in your main table.

Edhy Rijo

Attachments
Combobox_ListPopulationSettings.png (130 views, 38.00 KB)
Philipp Guntermann
Philipp Guntermann
StrataFrame User (231 reputation)StrataFrame User (231 reputation)StrataFrame User (231 reputation)StrataFrame User (231 reputation)StrataFrame User (231 reputation)StrataFrame User (231 reputation)StrataFrame User (231 reputation)StrataFrame User (231 reputation)StrataFrame User (231 reputation)
Group: Forum Members
Posts: 141, Visits: 263
hi !

thanks for the screenshot. so i set the list population like on the screenshot in my case using PropertyGroupsBO and then i set the BusinessObject-Property of the combobox to Properties, i guess ?

Edhy Rijo
E
StrataFrame VIP (4.7K reputation)StrataFrame VIP (4.7K reputation)StrataFrame VIP (4.7K reputation)StrataFrame VIP (4.7K reputation)StrataFrame VIP (4.7K reputation)StrataFrame VIP (4.7K reputation)StrataFrame VIP (4.7K reputation)StrataFrame VIP (4.7K reputation)StrataFrame VIP (4.7K reputation)
Group: StrataFrame Users
Posts: 2.4K, Visits: 23K
Philipp Guntermann (03/03/2009)
... in my case using PropertyGroupsBO and then i set the BusinessObject-Property of the combobox to Properties, i guess ?

Yes, and you use bind the combo to the FK field in the PropertiesBO.

Edhy Rijo

Philipp Guntermann
Philipp Guntermann
StrataFrame User (231 reputation)StrataFrame User (231 reputation)StrataFrame User (231 reputation)StrataFrame User (231 reputation)StrataFrame User (231 reputation)StrataFrame User (231 reputation)StrataFrame User (231 reputation)StrataFrame User (231 reputation)StrataFrame User (231 reputation)
Group: Forum Members
Posts: 141, Visits: 263
that makes sense. Thanks for your explanation.

gonna try that tommorow BigGrin

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search