Forum home » Delegate support and help forum » Microsoft Access Training and help » ms access training - I woul like to know more about connecting relationship?
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
ms access training - I woul like to know more about connecting relationship?
Resolved · Low Priority · Version Standard
Reply Fri 20 Jul 2007, 09:52Delegate Jeannie said...
Jeannie has attended:
Access Intermediate course
Access Advanced course
I woul like to know more about connecting relationship?
I could not find the way to joint the two or three relating deta to be joint together.
For upcoming training course dates see: Pricing & availability
RE: I woul like to know more about connecting relationship?
Using SQL you can achieve this.
Use a SELECT QUERY to select the data from the different tables and use the UNION command tojoin them together.
So, it looks like this:
SELECT [Table1.field1],[Table1.field2],[Table1.field3],
FROM Table1
UNION
SELECT [Table2.field1],[Table2.field2],[Table3.field3],
FROM Table2
Field 1, 2, and 3 must be the same data type
|
|