Do I need a querry to combine two tables?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
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!
Click to expand...

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]
 
Back
Top