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.

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

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.

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 ?

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

gonna try that tommorow