I just had a new laptop assigned to me at work. Running Office 2003 and once again, I have to reconfigure many of my personal settings. I also noticed that I have no query wizards.
And as luck would have it, I've been asked to assist in fixing a database that has allowed tables that should be linked to develop orphaned records.
The link field had a complicated naming convention but it was decided to simplify things. The solution was to rename the field value, but when that occurred, the related tables lost their link.
My SQL skills are very rusty. I need an unmatched query that looks at the link field of the related tables and compares it to the master table and only returns the records that it cannot find a match. It only needs to return the ID field and name field of the related tables. Any suggestions would be welcomed.
Additionally, if anyone know what I need to do to restore the query wizards, that too would be appreciated.
And as luck would have it, I've been asked to assist in fixing a database that has allowed tables that should be linked to develop orphaned records.
The link field had a complicated naming convention but it was decided to simplify things. The solution was to rename the field value, but when that occurred, the related tables lost their link.
My SQL skills are very rusty. I need an unmatched query that looks at the link field of the related tables and compares it to the master table and only returns the records that it cannot find a match. It only needs to return the ID field and name field of the related tables. Any suggestions would be welcomed.
Additionally, if anyone know what I need to do to restore the query wizards, that too would be appreciated.
