>>Is there any known issues or problems with creating view and using them to display info in a grid or multiple controls such as following:
>>
>>

>>SELECT Orders.o_orderid, Orders.o_i_instid, Orders.o_p_productid,;
>>  Orders.o_v_vendorid, Orders.o_orderno, Orders.o_orddte, Orders.o_ordcomp,;
>>  Orders.o_qty, Orders.o_unitprice, Orders.o_orderedby,;
>>  Institutions.i_instid, Institutions.i_instname, Vendors.v_id,;
>>  Vendors.v_name, Products.p_productid, Products.p_productname,;
>>  Products.p_qtyperunit, Products.p_unitprice, Products.p_unitsinstock,;
>>  Products.p_unitsonorder, Products.p_reorderlevel,;
>>  Products.p_warehouseno, Products.p_modifieddate, Products.p_memo,;
>>  Products.p_desc;
>> FROM ;
>>     warehouse!orders ;
>>    INNER JOIN warehouse!institutions ;
>>   ON  Orders.o_i_instid = Institutions.i_instname ;
>>    INNER JOIN warehouse!vendors ;
>>   ON  Orders.o_v_vendorid = Vendors.v_id ;
>>    INNER JOIN warehouse!products ;
>>   ON  Orders.o_p_productid = Products.p_productid
>>

>>
>>I did a drag and drop from this view above onto my form and it wouldn't put any of the fields.
>
>Did you add this view into form's DE in design-time?
>
>What exactly is your problem? It may be a bit tricky to update multiple tables, but for display purpose it should work just fine.


Thanks for replying back Naomi, not having any problems and it is in my data environment. I didn't know if it was a problem updating. I could always update individual base tables, use this view just to display. Just wanted to make sure there were no unforseen problems with the view if just displaying and not updating the view.

thanks
Nick