T TarBall Registered User. Local time Today, 09:38 Joined Jul 25, 2005 Messages 11 Aug 16, 2005 #1 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.
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.
ghudson Registered User. Local time Today, 09:38 Joined Jun 8, 2002 Messages 6,194 Aug 16, 2005 #2 Use a query or SQL as your data source and join the two tables as your forms record source.
T TarBall Registered User. Local time Today, 09:38 Joined Jul 25, 2005 Messages 11 Aug 16, 2005 #3 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?
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?