databind question

[CGreenMTU]

I have a drop-down menu which populates 3 textboxes based on the selection in the drop-down menu. The drop-down menu is populate thru TablePolicy, and fills the 3 textboxes from TablePolicy. I also have a search set up in one of the textboxes (search by Claim Number), which populates other textboxes with data relating to the searched Claim Number. The data (excluding the drop-down/3 textboxes) are bound to a different table (TableMaster) in the database. However, both tables are joined in a dataset. When I do a search, I cannot fill the 3 populated textboxes with data from the search because they are binded to the fields in TablePolicy. Is there anyway to possibly bind a texbox to two different fields in 2 tables? does this make any sense? sorry...

thanks in advance

 

[JCruz063]

I don't use binding quite that often but the first thing that comes to mind is to rebind the TextBox object to the new field when the appropriate button is clicked. Have you tried that?

JC

_________________________________________________
To get the best response to a question, read faq222-2244.