Hello,
ive also posted this in another forum because i didnt know where to put it! sorry if uve read it twice!
I want to set up a query and/or a report which will display data in two tables, linked to a common field from another table.
The structure is as follows:
A form and its details are recorded in tblForms, key field 'Form ID'. Each form may have a 'route type a' or a 'route tpye b' or both, so there is a 'tblroute type a' and 'tbl route type b' with ID, and linked to Form ID on tblForms.
So, when i create a query or report, and ask it to display the Form ID, and its corresponding route a and/or route b, it will only display those forms which have BOTH route a type and route b type.
However, some forms have one, some have the other, some have both.
How do i tell access to display ALL form IDs, and corresponding 'route a tpye' and 'route b type', and if there isnt say for example a 'route a type' for a form, to still display it (as blank say under the 'route a type' column) so it can display the 'route b type contents'?
I hope that makes sense.
I was thinking along the lines of criteria which justs selects all forms whether they have an entry in each table or not, and just to display blank in one column if say it doesnt have both route types.... but i dont know how!!
Cheers, much appreciated in advance.
Rob
ive also posted this in another forum because i didnt know where to put it! sorry if uve read it twice!
I want to set up a query and/or a report which will display data in two tables, linked to a common field from another table.
The structure is as follows:
A form and its details are recorded in tblForms, key field 'Form ID'. Each form may have a 'route type a' or a 'route tpye b' or both, so there is a 'tblroute type a' and 'tbl route type b' with ID, and linked to Form ID on tblForms.
So, when i create a query or report, and ask it to display the Form ID, and its corresponding route a and/or route b, it will only display those forms which have BOTH route a type and route b type.
However, some forms have one, some have the other, some have both.
How do i tell access to display ALL form IDs, and corresponding 'route a tpye' and 'route b type', and if there isnt say for example a 'route a type' for a form, to still display it (as blank say under the 'route a type' column) so it can display the 'route b type contents'?
I hope that makes sense.
I was thinking along the lines of criteria which justs selects all forms whether they have an entry in each table or not, and just to display blank in one column if say it doesnt have both route types.... but i dont know how!!
Cheers, much appreciated in advance.
Rob
