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