Steve wrote:
I have to tables
Table1
IMS_ID
IMS_Name
IMS_Descript
Table2
P_IMS_ID
P_IMS_Name
P_IMS_Descript
I want to show records that are in Table1 but not in Table2 or
records that are in Table2 but not in Table1
Anyone doing anything like this and how did you do it. I want to make
this a report on my Switchboard.
Thanks
Steve
You can do a Query/New/Unmatched and let the wizard write the SQL statement.
Manually, you could do a Query/New/Design for Table1 as the first step.
Select/add the two tables. Drop the fields from Table1. Drop the
P_IMS_ID field from Table2 to a column as well. In the criteria enter
"Is Null" in the criteria row of the P_IMS_ID column. Then drag the
IMS_ID to P_IM_ID in table2 to create a link line between the two
tables. Then dblclick on the line and select the "Select All records in
Table1 and matching in Table2" option. Save and run. Reverse the
tables and fields to create the second query.