>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