StrataFrame Forum
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      


««12

Combo values based on another combo valueExpand / Collapse
Author
Message
Posted 06/14/2008 5:09:04 PM
Advanced StrataFrame User

Advanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame User

Group: StrataFrame Users
Last Login: Today @ 8:39:16 AM
Posts: 619, Visits: 2,552
Juan Carlos,

All you need to understand here is how the relation between the 3 tables works, then in the Combobox.SelectedIndexChanged you have to check the ParentBO.Count > 0, so if there is a record, then you can sent the ParentBO.PKFieldValue to the first parameter e.Parameters(0).Value = Me.ParentBO.PKFieldValue.

In the Categories Combobox SelectedIndexChanged use this code:

If Me.CategoriasPubBO.Count > 0 Then

     e.Parameters(0).Value = Me.CategoriasPubBO.YourPKFieldNameHere

Else

     e.Parameters(0).Value = 0

End If

Also I believe it is better to use sample with your real entities name, even if it is in Spanish, this way it will make more sense when posting real code .

 
Post #17069
Posted 06/14/2008 6:26:37 PM


StrataFrame Novice

StrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame Novice

Group: StrataFrame Users
Last Login: 09/23/2008 12:35:43 AM
Posts: 76, Visits: 135
Hi Edjy

Thanks for all your support. I still trying. If your have some simple sample, will be very good?

I think that in the ListPopulating should go the:

If Me.DetalleSubcategoriasBO.Count > 0 Then

e.Parameters(0).Value = Me.DetalleSubcategoriasBO.IdStio

Else

e.Parameters(0).Value = 0

End If

And in the SelectedIndexChanged the Requery()

Regards.



Everything is possible, just keep trying...
Post #17071
Posted 06/14/2008 8:29:55 PM


StrataFrame Novice

StrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame Novice

Group: StrataFrame Users
Last Login: 09/23/2008 12:35:43 AM
Posts: 76, Visits: 135
Hi

All solved. Thanks a lot for your help.

Everything is possible, just keep trying...

Post #17072
Posted 06/14/2008 8:33:28 PM
Advanced StrataFrame User

Advanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame User

Group: StrataFrame Users
Last Login: Today @ 8:39:16 AM
Posts: 619, Visits: 2,552
You're welcome Juan.

 
Post #17073
Posted 06/16/2008 9:22:40 AM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: Today @ 8:51:57 AM
Posts: 4,557, Visits: 4,544
Good stuff   Good answers, Edhy!
Post #17086
Posted 06/16/2008 9:41:44 AM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: Today @ 8:51:57 AM
Posts: 4,557, Visits: 4,544
Better yet, if you could post a sample versus my brain having to do the compiling and execution that would be great
Post #17089
« Prev Topic | Next Topic »

««12

Reading This TopicExpand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Ben Chase, Trent L. Taylor, Steve L. Taylor

PermissionsExpand / Collapse

All times are GMT -6:00, Time now is 8:54am

Powered by InstantForum.NET v4.1.4 © 2008
Execution: 0.094. 10 queries. Compression Enabled.
Site Map - Home - My Account - Forum - About Us - Contact Us - Try It - Buy It

Microsoft, Visual Studio, and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.