Do I need a querry to combine two tables?

[jr91403]

I am designing a database where I have costumers with multiple delivery
addresses. I created a form for the customers with a subform for delivery
addresses. I want to print out a delivery slip from a comand button on this
form. My questions is do I have to go through a query? When I looked at
the Northwind db, they created the invoices query to combine data from
several tables. It that what I need to do? I would really appreciate any
help anyone can give me on this. I'm kind of jumping into the deep end here!

Thanks!

 

[Jeff Boyce]

Janet

If the data you need to "assemble" comes from more than one table, use a
query to join the tables and retrieve all the data you need.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John Vinson]

I am designing a database where I have costumers with multiple delivery
addresses. I created a form for the customers with a subform for delivery
addresses. I want to print out a delivery slip from a comand button on this
form. My questions is do I have to go through a query? When I looked at
the Northwind db, they created the invoices query to combine data from
several tables. It that what I need to do? I would really appreciate any
help anyone can give me on this. I'm kind of jumping into the deep end here!

Thanks!

In my experience, the vast majority of (non-trivial) reports are
indeed based on queries. They typically pull data from multiple tables
- in this case perhaps the Invoices, Customers, and Addresses tables.

Note that the Form is *just a window* - a tool to get data into your
tables. Your Report (the printed delivery slip) prints data from the
tables, not from the form. You can use a field (say the InvoiceNumber)
on the Form as a criterion for the query, though - use the syntax

=Forms![NameOfYourForm]![NameOfTheControl]

on the Criteria of your query.

Queries are your friends. Get to know them! <g>

John W. Vinson[MVP]