Make a value list with custom value (month names)
User select one on a field
Get value using
Evaluate ( "tableName::" theFieldUserChooseAMonth )
But, totally I feel something bad building of database structure, seeing "layout named Client 1,..."
I have one tabel with filed IDs of powermeters and other 12 field wiht registers of power meters at 00:00 HH on 1 Janyary, February, March........ Anad I have other tables with Clients. Each clients have numbuer of powermeters - 1, 2, 5, 20. To calculate energy consumption (example August) i have to substract registers from 1 September and 1 Agust. I want to make labels with Client 1, Client 2........ and to calculate the consumption energy for different period (months) which I have chosen......
I can't handle