Open Form Using Multiple Tables

TarBall

Registered User.
Local time
Today, 09:38
Joined
Jul 25, 2005
Messages
11
I have 2 tables, Test Cases, Test Case Details. I have a tabbed form to display the data. How do I open the form and retreive the data from both tables? Tables are related by ID.
 
Use a query or SQL as your data source and join the two tables as your forms record source.
 
Yeah I used the search but didnt find what I needed (and its slow).

Never used Shaped RecordSets. Is there a benefit to using a shaped set versus JOIN?
 

Users who are viewing this thread

Back
Top Bottom