unbound column in table component

[ErikJJ]

Hi,

I have a table control (the component) in my OOo base form which contains 4 columns:
id, price, amount, total

The corresponding mysql table contains 3 columns:
id, price, amount (without total)

Now I made a macro which computes the total price. I can store this value in a single text field, but not in the corresponding row of the column 'total' in the table. I only use this for the users convenience.

But the problem is that this value cannot be stored in the table control, since there is no column not bound to any column in the data table. Of course i can add such a column, but that is really ugly...

Is there a way to tell base that this is a temporary field/columns? Or to link them with an array or something?

Thanks!