Hi Dmitry,
Nice to see you here :)
Just a shot: could it be done using triggers?
>I need to create a calculated field in one table based on SUM of another field in another table.
>Example: Parts Table: PART_NO, PART_DESCR, etc.
> Quantity Table: PART_NO, QTY, UNIT_PRICE
>
>Since Quantity Table can have more than one record for the same part (different unit price), I need to create a calculated field in Parts Table which will sum QTY for the part in Quantity Table.
>I need this field for use with SFReports so that user can create a report for Parts Table and show Qty for each part.
>
>How would you do it, create this type of calculated field in SDT? Any other suggestions would be greately appreciated.
>
>TIA,
>Dmitry
If it's not broken, fix it until it is.
My Blog