Try moving LocationCombo.Value and SupplierCombo.Value and CustomerCombo.Value into variables and use the variables in the view's where clause instead of 'THISFORM.xxx.value'


>The error generated by the cpode below is
>Command contains unrecognized phrase/keyword
>
>CREATE SQL VIEW "ORDERID" AS ;
> SELECT Ordhead.orderid, Ordhead.customerid, Ordhead.location, ; Ordhead.entered, Ordsize.PRODUCT, Ordsize.ordered, Sizetype.DESCRIPTION, ;
> Ordsize.sizetypeid,PRODUCT.CODE ;
> FROM frantisi!Sizetype, frantisi!Ordprod, frantisi!Ordsize, frantisi!Ordhead, frantisi!PRODUCT ;
> WHERE Ordsize.PRODUCT = PRODUCT.productid ;
> AND Ordhead.orderid = Ordprod.orderid ;
> AND Ordprod.orderprodid = Ordsize.orderprodid ;
> AND Ordsize.sizetypeid = Sizetype.sizetypeid ;
> AND (Ordsize.location = ?THISFORM.LocationCombo.VALUE OR EMPTY(?THISFORM.LocationCombo.VALUE)) ;
> AND (PRODUCT.supplier = ?THISFORM.SupplierCombo.VALUE OR EMPTY(?THISFORM.SupplierCombo.VALUE)) ;
> AND (Ordhead.customerid = ?THISFORM.CustomerCombo.VALUE ;
> OR EMPTY(?THISFORM.CustomerCombo.VALUE)) ;
> AND Ordsize.ordered > 0))
>
>
>This usually means a typo... and I am not seeing it.
>
>Maybe fresh eyes can help?
>
>TIA,
>Mike