Hi,

At October 13, 2004, 18:18, Rick DeBay wrote:

> I just checked the dependencies table, and the PRODUCTID field is not in
> the table, so this won't work.

It has to be there. Try looking for the view name in the field
RDB$DEPENDANT_NAME, and then you should see the field name PRODUCTID,
under RDB$FIELD_NAME.

> However, trying to delete the field from
> the table yields:

> Column PRODUCTID from table CLAIMSPAIDREVERSED is referenced in view
> V_INVOICED_CLAIMS.

> Would I modify RDB$RELATION_FIELDS?

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)