How do I populate a subform field with a value from the main f
On Tue, 18 May 2010 07:19:01 -0700, SSi308
wrote:
How does the table know who the record is for when running reports?
For example the ContractsAndHours subform was created from the
ContractsAndHours table. If I do a query on the ContractsAndHours table
information and there is no name field how do I sort by employee name?
Join the Employees table in the query: pull the contract and hour information
from the ContractsAndHours table, and the name from the Employee table. That's
what relational databases DO - let you combine data from multiple related
tables into one result.
If you're assuming that the Report must be based on a single table containing
all the needed information, you're missing the real power of databases!
--
John W. Vinson [MVP]
|