Hi Friends,
I have a master form displaying automobile parts and linked to a detail from via field “Part_No”. In detail form, it displays who “Customer”, “Date”, " Price", and “Quantity”.
When I navigate through each part (master form), the details chaanged according the “Part_No”.
Now, I want to add a “filter”. So in a master form, I add a non-database field says" Cust_Name". If there is any changes in “Cust_Name”, I want the detail form to display the details on the that particular parts but only the customer that matches “Cust_Name”.
What would be the easiest way to implement this? Ajax? Php? Button? I tried some parameters passing but the detail form does not update the SQL unless I navigate through another record. Your example/help is much appreciated.
Thanks.
Ruecha