Subject | Computed By Column |
---|---|
Author | Gerhardus Geldenhuis |
Post date | 2001-09-27T15:31:30Z |
Hi
I think that computed by as a field type is limited to the table in which it
resides.
Can I used ufs in a calculated field computed by clause and what else can I
do.
My problem is I have a invoice table and in invoice items table.
The customer want to be able to give discount on the total invoice and per
item. In the invoice items table he wants to see what the profit margin is.
To do this I need to know the value of the discount in the invoice table
which is the master. Can this be done in a calculated field or how do you
suggest I do it.
Thanks
Groete
Gerhardus
I think that computed by as a field type is limited to the table in which it
resides.
Can I used ufs in a calculated field computed by clause and what else can I
do.
My problem is I have a invoice table and in invoice items table.
The customer want to be able to give discount on the total invoice and per
item. In the invoice items table he wants to see what the profit margin is.
To do this I need to know the value of the discount in the invoice table
which is the master. Can this be done in a calculated field or how do you
suggest I do it.
Thanks
Groete
Gerhardus