Hi everyone, I am making a database for profits or loses in stocks. I have a table called tblOperational and this table is related with another three, tblBuys, tblSells and tblStops, the relationship are 1 to many since tblOperational because 1 operational can have many buys, many sells and many stops. By the other side, there is a table called tblCommission where i have the commissions that i have to pay to the broker, this commission can change with the time or the number of operations that i make, the relationship of tblCommission is 1 to many to the tables, tblBuys, tblSells and tblStops.
I want to make a form with 3 subforms, subformBuys, subformSells and subformStops. The problem come when I want to calculate the commission in each subform for any buy, sell or stop. Imagine that I make a buy of 20 titles of AAPLE to 200$, the total of the operation is 4000$, over this 4000$ I have to calculate the commission using fields in the table tblCommission and the field totalOperation(4000$) of subformBuys. I make the next, in the subformBuys I put a independent textbox called txtCommission and using the expression generator put the next =[tblCommisssion]![percentage]*[tblBuys]![totalOperation]+[tblCommisssion]![valuefix].
Well this should show me a amount of money but show me #¿Name?. I dont know what I am doing bad. Please help me because I think that is not difficult.