I was able to get it working after going through the EXECUTE AS (Transact-SQL) article with fresh eyes. I didn't set the impersonate permission on the user account. To set...

Thanks SP. I kinda understand what you posted but a bit lost. Can you clarify this based on my questions above?

Thanks everyone. Great input. No school project, just thrown into the fire without much experience in creating databases. Also, not using "tbl" on the tables, just noted it in the...