IMO, and I could be wrong ;-> you have 2 views for the states in the same bizobj. Each view will be bound to the proper data column State, Other State. Now everything should work just fine. Now State could be NE and Other State could be NM.

__Stephen


>Stephen,
>
>I am using a ComboBoxL control with a business object to load a view as a RowSource. If I have 2 state fields and therefore two ComboBozL controls on my form, I think I need two distinct views to allow both ComboBoxLs to operate independently.
>
>Or am I missing something?
>
>TIA
>
>Rex
>
>>>All,
>>>
>>>Silly question!
>>>
>>>I have a patient table with a State and a Birth State field. I need to enter both fields on the same screen and I am sure I cannot use the same view for both controls without having both state fields saving the same value.
>>>
>>>Is there any other way beside creating another view to handle the second state field?
>>>
>>>I told you it was a silly question!
>>>
>>>TIA
>>>
>>>Rex
>>
>>

---

>>
>>Are they both called State in different tables?
>>
>>If so no problem! download the EView program here in the files section and you can define which table the state field belongs to.
>>
>>Otherwise they are in the same table hand have different names. The update of data will be the same as any other using a view.
>>
>>__Stephen