I am confused on how to use the PHP API, hopefully you guys could provide your kindly advice.
There are two tables, Customer and Service, and they have belows items;
Customer (customer_id, customer_name)
Service (service_id, customer_id, service_name, service_price, total_price)
I want to use the keyword of "customer_name" to find all related service from Service table in PHP pages.
My current logic is to use the keyword of customer_name to lookup Customer table to locate the customer_id, and then use the customer_id to lookup the Service table.
I notice that using the API of "newFindCommand", I need two times lookup, $fm->newFindCommand('Customer') and $fm->newFindCommand('Service').
Are there any easy way to implement my requirement instead of multiple time lookups. thanks.