Subject Re: [IBO] M/D Field Not Found
Author Helen Borrie
At 11:25 AM 26/08/2003 -0700, you wrote:
>I have several M/D relationships with them all working fine (using
>TIB_Query and TIB_Datasource), but am having problems with a a pair of
>detail and a master: I can not get them to work on inserting. I get an
>exception stating that the field is not found.
>
>The relationship is:
>
>
>MasterTable ("SPLITANNPRODUCTS")
>SPLITANNPRODUCT_ID [PK]
>.
>
>Detail Table
>.
>SPLITANNPRODUCT_ID [FK]
>
>I have set it up so that the TIB_Datasource points to the master table
>and the detail table's MasterSource is set, and the MasterLinks is set
>to
>
>SPLITANNPRODUCT_ID=SPLITANNPRODUCTS.SPLITANNPRODUCT_ID
>
>Everything works fine if I remove the master link and manually set the
>value-but I would like to know what it isn't working correctly.
>
>Suggestions to look at?

Are you using quoted identifiers for your tables and/or columns? If so,
you have to use them everywhere and everything is case-sensitive.

Helen