Okay, here is what I think should work. In the column for hours. We should be able to enter something like this.
SELECT(Prรกce[Hodiny],[_THISROW].[ID]=[zakazka])
This will find the hours associated with the order we have. This is not substaintially different than REF_ROWS() but if that wasn't working then this is another option.
Then for the type of the column here it would be a decimal and you can set how many digits and such you would like. I believe this would work, I have tested it in an app with a similar structure.
The final thing I would say, I noticed that your zakazka ref column in your Prรกce table is; a reference, a key, and a label. I have never done that with something. It may be giving you some trouble having it be both a reference and the key I would recommend nott using the same column as both a foreign key and a primary key. You could have a column on the left be an ID column that serves as your primary key then keep that as the next one for the foreign key. (Column 1: ID column 2: foreign key ... everything else the same. Then regenerate structure.)
I believe this should solve it. If it still gives you trouble. I can try to mimic your app and include some screenshots but I believe this is the solution.
Craig
QREW Technologies
LinkedIn
Twitter
