How do I get database results from two tables that have a one to many relationship?

Hi,
you'll need to enter a custom query (step2 of the wizard) something like

SELECT A.Field1, A.Field2, B.Field1
FROM TableA A INNER JOIN TableB B ON A.ID = B.ID

You may find it easier to build your query in Access or Enterprise Manager
(if you using sql server) then copy and paste it into FP

--
Cheers,
Jon
Microsoft MVP - FP


"Computernations" <(E-Mail Removed)> wrote in message
news:77B90EFA-5197-469F-8B51-(E-Mail Removed)...
> How do I get database results from two tables that have a one to many
relationship?

That worked great. Thanks!