Will need to create a Query the create a Join That Shows all records from one Side Which Then create a Blank Records(Null value on the other side)
Then only show all null records Bla you have got Missing records Showing
When you join the above 2 table by the 1id=>2id and set the join type
so it show all records form table1 and those records in table 2
record 2 and 3 will have a blank(null) text2
then only showing the nul value Will show what reocrds are missing from table2 that should be in table1
hope this help
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
VB-NET based on my own environment started 2007
SQL-2005 based on my own environment started 2008
YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
THEY'RE BEHIND YOU FOR A REASON