Hi Jerome,
I appreciate your help and thank your patience.
Alright, I will tell you in details what I was trying to do and will answer your generous replies for all my topics; however, let me go directly to questions at the mean time just to finish my late project and focus afterwards on developing what is better for all of HikaShop fans.
Speaking about the front-end main vendor order listing view:-
In the database table hikashop_order there's a column called "order_vendor" (which I have created using the custom field feature).
I want a string that for each hkorder.order_id in the listed table, it fetches the corresponding value from the column order_vendor , then it goes to the table hikamarket_vendor and locate the fetched value in the vendor_id column then finally print the corresponding value from vendor_name column.
Is there a way to do that using, for example, HikaShop MVC?
Your prompt and positive feedback is gratefully thanked,
Sincerest regards.