AnsweredAssumed Answered

FileMaker PHP API Issues

Question asked by windtech on May 3, 2018
Latest reply on May 7, 2018 by user19752

Hi There

 

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.

Outcomes