> I want to select only those rows from OrdHdr where
> status in ('S','E','C')
> What would be the correct syntax to accomplish this?
You cannot, in the EDIT USING command, specify
conditions to apply to tables other than the first
table in the form.
Instead, create a single table view on OrdHdr like
this:
CREATE VIEW OrdHdrSECOnly AS +
SELECT * FROM OrdHdr +
WHERE Status IN ('S', 'E', 'C')
and then use that view, rather than the actual OrdHdr
table, as the third "table" in your form. Because the
view is limited to the rows you want, only those rows
will appear. Because the view is single table, you
will be able to edit the values.
--
Larry
