Column based on a query
Column based on a query
Hello, I need to create a table with 4 columns, the last column being a query on another table. Example:
Table 1:
User_ID LastName FirstName Expenses
-----------------------------------------------------------------
The Expenses column should be a query on another table which takes the user ID in account. The data in the other columns of Table 1 are entered manually.
Will a Query Table do this?