Hi Guys,

Is this possible?

Code:
Table1:
Description     Quantity
Item 1           10

Table2:
Description     Amount
Item A           20

Persisted:

CREATE TABLE Table1
(
   DescriptionID INT IDENTITY (1,1),
   Description VARCHAR(255),
   Quantity DECIMAL(18,2)
)

CREATE TABLE Table2
(
   DescriptionID INT IDENTITY(1,1),
   Description VARCHAR(255),
   Amount DECIMAL(18,2),
   Total AS (Table1.Quantity * Amount) PERSISTED
)
Thanks in advance.