Selecting data from multiple tables

rbuser

I have 1 query that grabs customer info. I have another that grabs invoices
that customer has on file. However, How do I have the second query only
grab records for that customer? Instead of grabbing them all and linking
the table result to the customer query. But in this case I'm basically
doing a select all and really on want the few that go with that particular
customer?

Thanks,

glenn

nicocizik

Hi Glenn,

You could either create a Master-Detail relationship between the two queries
and link them. Then selecting a certain customer in the master will only
return those records in the detail. You could also try simply joining both
tables on the Master Key and selecting the customer as you need. Both
options are available in DADE.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com