Hi, I'm going to make an empty child table which reference to master table and only containing virtual columns. The child table just work as a part of master table, so I have not to input anything in the child table. Example:
Master Table
| RowID | Price | Amount |
| 1 | 100 | 10 |
| 2 | 110 | 20 |
| 3 | 120 | 7 |
Child Table
| RowID (Ref to Master Table) | Calc (Virtual) |
| Same With Master Table | [RowID].[Price] * [RowID].[Amount] |
| | |
Kind regards
LinkedIn
Twitter
