Perhaps you need to explicitly name the column in the view - the form may not see
t1.whatever as equal to 'whatever'
[EMAIL PROTECTED] wrote:
>
>
> Hello all gurus:
>
> � � Over the weekend I attempted to use a view as the
> driving table for a form. �I then located a second table on
> the form. �The view and the table have a common column of
> ID.
>
> � � What I found is that the records in the second
> table displayed all the records it contained �regardless of
> whether the id matched in the driving view. �Is this normal?
>
> � � Is there some rule about using a view as the
> driving table in a form? �
>
> � �
> ----------------------
> Bob Powell
> The Hotchkiss School
> Lakeville, Connecticut
> Systems Administrator
> [EMAIL PROTECTED]
>
>
__________________________________________________________________
Get your own FREE, personal Netscape Webmail account today at
http://webmail.netscape.com/
