Dear all,
Apologies for the newbie question.
I have a form calculating a discount on a "TotalPrice" field based on the supplier name.
On the suppliers table there is a "discount" field for every supplier (0,1 for 10% disc)
I did the calculation on the actual form, based on a query with a calculated field.
I would actually prefer to to do this as a calculated field on the table, as I don't need the information on the form.
I can imagine that I should still base the calculation on the query, since it would actually be the vlookup-"ish" function, is this correct? In that case, how should I do this? in the actual table on the back end? I am confused, since the back end does not contain the query.
Apologies for the newbie question.
I have a form calculating a discount on a "TotalPrice" field based on the supplier name.
On the suppliers table there is a "discount" field for every supplier (0,1 for 10% disc)
I did the calculation on the actual form, based on a query with a calculated field.
I would actually prefer to to do this as a calculated field on the table, as I don't need the information on the form.
I can imagine that I should still base the calculation on the query, since it would actually be the vlookup-"ish" function, is this correct? In that case, how should I do this? in the actual table on the back end? I am confused, since the back end does not contain the query.