- Create a query
- Add both tables on the design grid
- Drag the common field from one table to the other
- Add all the fields you want to display from the table down into the query grid
- Run the query
I have a form where I am trying to use the data from one table on the main form and the data from a second table on a sub form.
I created a query using al the fields from the main table (feeds the main form) and all the fields from the second table (feeds the sub form.) doing as you outline above.
I linked the 2 tables on one field.
The fields contain the same data but have slightly different names. (SerialNumber --- CPUSerualNUm)
When I run the query, I get no results.
If a create a query with just all the fields from the first table I get all records. (over 6700 results)
The second table as structure but no data yet as I will be using the form to enter that data.
The query was created using the query wizard.