Understanding of field relationship between tables is important.

Hope, following structure will help you,

Customer

Vendor