Fill data table column based on another column from another table (reference table)?

[Shan1986]

Hallo,

I have 2 data tables, one is standard rate table which has a predefined hours and rates for a specific object. Another table which comes from a user with selected objects and quantities, in this table i have to apply standard rates and hours. What is the best way to achieve this ? should i make a data table relations or any other method or any example?



Thanks

Continue reading...