Thanks very much for your contributions...I really appreciate your support.However,to illustrate the real situation,below is the sample scenario with 3 sample tables;

Buyer table

BuyerIDLocationIDBuyer Name ...