i ve got three tables table 1 table 2 table 3 . I need to multiply the fields of table 1 with table 2 . To do that i use the following syntax Expr1: ([table1]*[table2]) and works fine . How can i restict this formula to a specific field on table 3 . To clarify this table1 =oranges table2 = 1 pound and table3 =customers .
i have to develop a way to find the sum of all orders(table1Xtable2) of specific customer . John exists many times in table 3 and many oranges have been ordered by him many times .