As per Question tag you may expect to insert data into 2 tables when you perform the action, for that create procedure and call 2 insert statements into that or else create 2 separate procedures and call those 2 procedures when you perform insert action.

As per your content you may expect to display the data using 2 tables, in that case use joins and proper joining conditions for fetching exact result.

Hope this will helpful to you..--------------------------------------------------------------------------------Give respect to your work, Instead of trying to impress your boss.