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 said:
How do I get database results from two tables that have a one to many
relationship?
