I have two tables, Account and Location, and I am trying to verify that the sales code and location id in the account table have a corresponding row in the location table. However, my problem is that in the location table, I have multiple rows for the same sales code. Can someone please provide some assistance on how I can verify that the sales code and location id values for each account are equal to the sales code and location id in the location table?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access 97
- Thread starter czink9
- Start date
- Status
Similar threads
- Locked
- Question