I have 2 tables :
I need to make field as Price*QTY= TOTAL SALES
i make other table as :
load QTY from Tbl2;
but is make many tables and cant make new field.......
how to join is ???
May be try with the mapping load:
Price * ApplyMap('MappingTable', ProductID) as [Total Sales]
How many mapping tables I can create ?
In theory unlimited.
So if you want to create 8000 mapping tables: Have fun.
mapping table include only 2 columns
if i work with 10 Tables.....for any new field i need made new mapping table............
You need all those fields in calculations?
If not, use JOIN the tables instead.
Retrieving data ...