Hi in general...
it is not a very good idea having blanks in a table or field name- i
guess it is illegal in SQL92 - how about "_" ?
Claus

Raymond Kennington wrote:

>Raymond Kennington wrote:
>
>>CREATE TABLE "Chemical Inventory Location"(
>> ID D_GENERATOR,
>> "Inventory ID" D_GENERATED,
>> "Location ID" D_GENERATED,
>> Units COMPUTED BY ((SELECT "Chemical Description".Units
>> FROM "Chemical Description" JOIN
>>"Chemical Inventory"
>> ON ("Chemical Description".ID =
>>"Chemical Inventory"."Description ID")
>> WHERE "Chemical Inventory".ID =
>>"Inventory ID")),
>> ...
>> );
>>
>>The last line of text causes the error message: Field unknown: "Inventory ID":
>>
>> WHERE "Chemical Inventory".ID = "Inventory ID"
>>
>>Given that "Inventory ID" is in the table, how can I make the SELECT statement
>>in the COMPUTED field recognise its existence?
>>
>
>I found the solution.
>

[Non-text portions of this message have been removed]